SQL Clone
SQLServerCentral is supported by Redgate
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 2015/05/05 | Source: SQLServerCentral.com | Category: user
Rating: |  Discuss |   Briefcase | 2,949 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 2015/04/10 | Source: SQLServerCentral.com | Category: stored procedure
Rating: |  Discuss |   Briefcase | 4,537 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,440 reads
   Items 1 to 3 of 3