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   


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 | 247 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 | 277 reads


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 | 173 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 | 655 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 | 730 reads
   Items 1 to 5 of 5