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

Scripts by Hakim Ali

SQLServerCentral.com profile

   Items 1 to 3 of 3   
 

Delete All Database User Accounts for a Given Server Login

Easily and quickly delete all database accounts even if they don't have the same name as server login.  Read more...
By Hakim Ali 2013/08/06 | Source: SQLServerCentral.com | Category: user
Rating: |  Discuss |   Briefcase | 1,506 reads

Find Stored Procedures and Functions That Reference Certain Tables

Find any code objects that interact with a given table/view, or call another given code object.  Read more...
By Hakim Ali 2013/08/02 | Source: SQLServerCentral.com | Category: stored procedure
Rating: |  Discuss |   Briefcase | 2,544 reads

Defrag All Indexes On a Database

Script to list out all fragmented indexes for a given database, with options to only view them, reorganize them, or rebuild them in one fell swoop.   Read more...
By Hakim Ali 2012/05/25 | Source: SQLServerCentral.com | Category: fragmentation
Rating: |  Discuss |   Briefcase | 2,308 reads
   Items 1 to 3 of 3