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

Content with tag process Rss

   Items 1 to 3 of 3   

Kill all USer Sessions before starting to restore a Database

If you have a requirement to Kill all USer Sessions before starting to restore a Database, you may use this script  Read more...
By S M 2015/08/05 | Source: | Category: sql restore
Rating: |  Discuss |   Briefcase | 1,458 reads

Identify last statement run for a specific SQL Server session

The process to return the last query statement executed is quite straight-forward and works in all versions of Microsoft SQL Server since DMOs (dynamic management objects) were integrated into SQL Server.   Read more...
By Additional Articles 2009/07/30 | Source: | Category: administration
Rating:  Rate this |   Briefcase | 4,206 reads

Easy and Repeatable Testing of DB Code (Stored Procs, etc.) with DbFit

Testing DB code is not fun or easy so it usually gets ignored. But now there‚Äôs a super-easy way to test using DBFit.  Read more...
By Solomon Rutzky 2008/11/13 | Source: | Category: testing
Rating: |  Discuss |   Briefcase | 9,743 reads
   Items 1 to 3 of 3   
administration (1)    
agile (1)    
dbfit (1)    
fitnesse (1)    
life cycle (1)    
sql restore (1)    
testing (1)