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

Scripts by Rajib Kundu

SQLServerCentral.com profile

   Items 1 to 2 of 2   
 

Figure out the Blocking issue

This script will help you to get the culprit along with IP address and User name which helps us to determine the Blocking root cause.  Read more...
By Rajib Kundu 2013/12/16 | Source: SQLServerCentral.com | Category: blocking
Rating: |  Discuss |   Briefcase | 2,151 reads

How we can move the login which has Sysadmin role.

We are using sp_help_revlogin to make login script, but it doesn't enable the login which has sysadmin role. It is very common problem during server migration. We use the this technique to solve the issue.  Read more...
By Rajib Kundu 2013/12/09 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 878 reads
   Items 1 to 2 of 2