Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Administration, SQL Server 6.5 Rss

<< Newer    Items 21 to 31 of 31   
 

Sweeping Up The Slackers

Have you ever worked with an application that forgot to close its connections? Ever run out of connections on your SQL Server and had to manually go remove the ones that are not in use? This article will present a technique for keeping the database clean.   Read more...
By Steve Jones 2001/05/07 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 4,992 reads

Using Xp_cmdshell

One of the most handy extended stored procedures in SQL Server is xp_cmdshell. This article will show you how to use it.   Read more...
By Brian Knight 2003/11/14 (first published: 2001/05/03) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 38,829 reads

Moving Logins - A Gotcha!

This article by Andy Warren talks about using sp_addlogin to move logins from one server to another. It also points out a problem you may run into if you have a SQL 7 server that was upgraded from 6.5   Read more...
By Andy Warren 2004/05/12 (first published: 2001/05/01) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 10,819 reads

Log Your Changes

How can you maintain a stable environment? Keeping track of all changes is the time-tested and proven technique. Read about it here.   Read more...
By Steve Jones 2001/04/30 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 5,336 reads

Automatically Gathering Server Information Part 8

The eighth part of Steve Jones's series on having SQL Server automatically report information to a DBA.   Read more...
By Steve Jones 2001/04/29 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 6,481 reads

Restoring the Master Database

This article shows you in a step-by-step manner how to restore the master database.   Read more...
By Brian Knight 2001/04/29 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 8,791 reads

Automatically Gathering Server Information Part 6

The sixth part of Steve Jones's series on having SQL Server automatically report information to a DBA.   Read more...
By Steve Jones 2001/04/25 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 5,480 reads

Automatically Gathering Server Information Part 5

The fifth part of Steve Jones's series on having SQL Server automatically report information to a DBA.   Read more...
By Steve Jones 2001/04/24 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 6,672 reads

Automatically Gathering Server Information Part 4

The fourth part of Steve Jones's series on having SQL Server automatically report information to a DBA.   Read more...
By Steve Jones 2001/04/22 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 5,702 reads

Automatically Gathering Server Information Part 3

The third part of Steve Jones's series on having SQL Server automatically report information to a DBA.   Read more...
By Steve Jones 2001/04/20 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 10,936 reads

Process Tracking

It is not always possible to run a process on a set schedule. This article by Steve Jones looks at a technique for ensuring that your processes can run on whenever you need them to without any loss of data.   Read more...
By Steve Jones 2001/04/18 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 4,634 reads
<< Newer    Items 21 to 31 of 31   
 
Tags
sql server 7 (16)    
monitoring (7)    
security (5)    
miscellaneous (2)    
programming (2)    
best and worst practices (1)    
configuring (1)    
dts (1)    
miscellaneous (1)    
performance tuning (1)    
sql-dmo (1)    
stored procedures (1)    
t-sql (1)    
worst practices (1)