SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts by Jim Youmans

SQLServerCentral.com profile

   Items 1 to 6 of 6   
 

Find UDF useage

Find all stored procedures that use UDFs  Read more...
By Jim Youmans 2017/03/21 | Source: SQLServerCentral.com | Category: sql
Rating: (not yet rated) |  Discuss |   Briefcase | 297 reads

Find all published tables with row counts and table size

This script will show you all the tables that are being published with sizes.  Read more...
By Jim Youmans 2017/03/16 | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 336 reads

SQL Login Password Audit

Audit you SQL Logins   Read more...
By Jim Youmans 2017/03/07 | Source: SQLServerCentral.com | Category: sql
Rating: |  Discuss |   Briefcase | 553 reads

Use HASHBYTES to identify changes

Use a hash to identify changes and process just the changed rows.  Read more...
By Jim Youmans 2013/11/25 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,945 reads

Restore Script Generator

Create restore script from a SQL Backup file. A must have for your DBA Tool Belt.  Read more...
By Jim Youmans 2013/06/18 | Source: SQLServerCentral.com | Category: restore
Rating: |  Discuss |   Briefcase | 1,917 reads

Search all stored procedures on all databases

Need to find every stored procedure in any database that references the table FooBar? Here is a quick and easy search to do that.  Read more...
By Jim Youmans 2013/05/30 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,559 reads
   Items 1 to 6 of 6