Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
New Server (7.0) in Enterprise Manager
We have added a 3rd server to our small site. When I start EM on my PC, the original servers go green in a second. It takes about 5 more seconds for the new server to go green. The only difference between the servers is that the new one is running on Win 2K and is much bigger and the data is...- marchanje
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
-
Indexes Question
Thanks James! Anyone know of any good articles dealing with the pros and cons of having "auto create statistics" on?- marchanje
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Indexes Question
The Manage Indexes option in EM shows 2 indexes for tblPersonnelInfo: PK_tblPersonnelInfo and SSN_tblPersonnelInfo Where did items 4 - 68 come from and why do they not show up in EM? Query, against sysobjects and sysindexes show lots more: Index information for Table: tblPersonnelInfo: 1...- marchanje
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
-
Copying database to another server
I hope it's ok, to add a new but related question to this thread! I am getting ready to move to a new SQL Server 7.0 Below is my simplified task list: Move Objects Method Status ============= =========== =================== User logins script Done User...- marchanje
- Post #11
- Forum: Microsoft SQL Server: Programming
