SQL Server Central is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
 

Guest Columnist: Robert Cary

SQLServerCentral.com profile

   Items 1 to 2 of 2   
 

Searching Syscomments Accurately

As a SQL Server DBA you should know that your code is stored in syscomments by default. While most DBAs use version control systems, there are times you might want to look through the code on the server for comparison purposes. Robert Cary brings us an article on how you can do this in 2000 and 2005.   Read more...
By Robert Cary 2007/01/22 | Source: SQLServerCentral.com | Category: Administering
Rating: |  Discuss |  Briefcase | 6,118 reads

Implementing a T-SQL semaphore

SQL Server does a great job of handling concurrency & ensuring that users can make changes in multi-user systems without conflict. However there are times a strict calling order is needed.   Read more...
By Robert Cary 2006/10/17 | Source: SQLServerCentral.com | Category: Miscellaneous
Rating: |  Discuss |  Briefcase | 6,974 reads
   Items 1 to 2 of 2