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

Scripts by Patrick Slesicki

SQLServerCentral.com profile

   Items 1 to 5 of 5   
 

SQLServiceAccountSelect

To get information for all SQL Server Services on a given SQL Server instance   Read more...
By Patrick Slesicki 2018/03/09 | Source: SQLServerCentral.com | Category: service accounts
Rating: |  Discuss |   Briefcase | 302 reads

Logins for Windows Groups

Returns all user logins for Windows groups registered on the instance.   Read more...
By Patrick Slesicki 2018/02/26 | Source: SQLServerCentral.com | Category: login
Rating: |  Discuss |   Briefcase | 354 reads

ReplicationDeltaSelect

To find record differences between publisher and subscriber tables by comparing primary keys.  Read more...
By Patrick Slesicki 2018/02/16 | Source: SQLServerCentral.com | Category: replication
Rating: (not yet rated) |  Discuss |   Briefcase | 197 reads

A Data Dictionary Select

Query for data dictionary using internals. Various constraint definitions included.  Read more...
By Patrick Slesicki 2018/03/14 | Source: SQLServerCentral.com | Category: data dictionary
Rating: |  Discuss |   Briefcase | 743 reads

String Search

This script performs a smart search against all fields of a database for a given "String." The TSQL checks all columns in all tables for data type appropriateness before performing the search. Works with numeric as well as character data types.  Read more...
By Patrick Slesicki 2018/02/13 | Source: SQLServerCentral.com | Category: string match
Rating: |  Discuss |   Briefcase | 804 reads
   Items 1 to 5 of 5