• SQL Server Schema Best Practices

    I am in the process of establishing a "sandbox" database for a mix of users with SQL development skills. I have done this before with Oracle but not with SQL Server. What I would like to do is build a database whereby each user has their own play area. We are running SQL Server 2005 so I thought of...

    MortimerSchnurd0 pointsBadges:
  • SQL 2000 to Yukon Migration

    We have 4-5 applications on the front end of a portal. On the backend we have mapped these applications to SQL server 2000 Databases. Now, we are planning to migrate on the backend databases to Yukon and map it to the application on the front end. My question: Is it possible to use Yukon for one of...

    Kilaru0 pointsBadges:
  • Triggers

    I was a cobol/db2 programmer for many, many, many years, and I now have the opportunity to work with SQL Server. That’s the good news…the bad news is NO training. I will have to learn this on my own. Do anyone have any suggestion on how to get started. My first project is to identify all of the...

    Mainframe dino0 pointsBadges:
  • database sql,with vb coding,first time running not fast

    we have an accounting package written in visual basic 6.0 and sql database,the problem is when we open the database the first time,it takes lot of time,but when we open it after, it will be very fast and remain fast ,even when we quit the application and restart it.

    Micus20050 pointsBadges:
  • SQL Server Tools do not show up

    Greetings, I have my laptop running MS SQL 2005. I upgraded from XP to Vista. When XP was installed, I had SQL 2005 Express and SQL Server 2000 running parallel. After installing Vista (clean) I decided to just go with SQL 2005. I installed SQL 2005 Express. Later, I installed the full server, and...

    Taersious15 pointsBadges:
  • Using MAX data types in SQL Server

    I'm new to using large data types (varchar(max))and after reading an article (Using MAX data types in SQL Server) I have a few questions. I am trying to understand how you insert such a long string (up to 2 billion char) in the database table? I am assuming this would include storing Word...

    Hank103925 pointsBadges:
  • Dynamic updates to a DNS Server

    What Windows Operating Systems support dynamic updates to a DNS Server? Which service needs to be running on the clients?

    1111100 pointsBadges:
  • What is NAT port forwarding?

    Describe in brief how you would set up port forwarding on a NAT router to allow a PC on the LAN to publish its web to the internet.

    1111100 pointsBadges:
  • DHCP relay Agent in DELL switches

    I have windows 2003 servers and Dell 62XX series switches (level 3 switches) and Vlans. As I understand in order for a computer to be able to receieve an IP Address via dhcp I need relay agent. This series of switches supports DHCP Relay my question is how would i assign computer to a specific...

    Dimchik0 pointsBadges:
  • Default User Profile

    I am in the unenviable position of administering an existing Windows2000 network consisting of one computer running Windows2000 server and three workstations running Windows2000 professional. They are configured as a domain. I would like to be able to set up a default user profile that would have a...

    Skyhawk8060 pointsBadges:
  • The time is wrong in one of my Domain controllers…………..

    Hi, There is something wrong in my domain from one week ago!!! I have two domain controller,the first dc name is DC and second is Mail,both of them is GC and the OS is Win 2003 server R2 sp1 I set the time of Mail and other clients by GP acording the time of DC: (net time \dc /set /y) I have some...

    Aliyani265 pointsBadges:
  • Lost Global Catalogue

    My Windows 2003 PDC recently died but prior to this I had transfered the operations master roles including schema master to my BDC. I was convinced my BDC was a Global Catalogue server but didn't get a chance to check before my PDC died. This happened just before I went away for 2 weeks and I only...

    ITBird15 pointsBadges:
  • Excel 2003 Cell has formula but empty Value or text

    Hya I have a formula into Excel worksheet cell this value comes from out side Excel. sometimes there is a number and sometimes it contains nothing. I have used isblank isempty when the cell is empty and they return true (due to the formula inside the cell) do u thing i can chek if the cell is empty...

    JonsIL45 pointsBadges:
  • SQL 2005 with running 2 Databases

    Can we install one instance of SQL 2005 on one server but running two different databases?

    Stemdriller5 pointsBadges:
  • SQL Server Connection

    I'm having a problem with one of my workstation which cannot connect to SQL server instance, while the other workstation can connect. The server is running on Window Server 2003 while the other client are running on window xp proffessinal. the fanny thing is i can ping the server but the...

    Gmmurage5 pointsBadges:
  • Windows XP System Hardening – Sysprep problem

    I'm currently going through a list of required security changes on one of our system that we use to create a master image to sysprep and clone to multiple target systems. I've made a large number of detailed changes to the system and now it appears that sysprep is unable to complete the mini setup...

    Watchman0 pointsBadges:
  • sql server 2000

    i have booted my system with windows xp as user xyz with limited rights not an administrator now problem is i am not able to run sql server.please tell me what should i do to run sql server 2000 in user xyz. *it works with administrator login.

    Css10 pointsBadges:
  • Cache Policy

    We are modelling a cube in analysis services 2005 which has custom rollup due to which the performance is very slow. If i use this property cache policy=9 the performance increases a bit. I tried it in 2 ways: 1. I changed the value of calculation cover policy to 9 in msmdsrv.ini . 2.I added the...

    Jothi155 pointsBadges:
  • Will cache policy=9 work in system that has MS analysis services 2000 or MS Analysis services 2005.

    Will cache policy=9 work in system that has MS analysis services 2000 or MS Analysis services 2005.

    Jothi155 pointsBadges:
  • how to run sql server 2000 on terminal which is logged on as user having limited rights

    how to run sql server 2000 on terminal which is lgged on as user having limited rights

    Css10 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following