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

Scripts by Paul Andrew

SQLServerCentral.com profile

   Items 1 to 5 of 5   
 

Test Your Linked Server Connections

Test your linked server connections and display the results.  Read more...
By Paul Andrew 2014/08/25 | Source: SQLServerCentral.com | Category: dynamic sql
Rating: |  Discuss |   Briefcase | 85 reads

Kill User Processes Per Database or Server Wide

Kill any user processes per database or for the entire server instance.  Read more...
By Paul Andrew 2013/09/05 | Source: SQLServerCentral.com | Category: kill processes
Rating: |  Discuss |   Briefcase | 1,291 reads

Create a Comma Delimited CSV File from Any Table/View with Debugging

Dynamically build a comma delimited CSV file using the BCP utility from any table or view in your database with a useful code debugging parameter.  Read more...
By Paul Andrew 2013/12/03 | Source: SQLServerCentral.com | Category: dynamic sql
Rating: |  Discuss |   Briefcase | 3,958 reads

Dynamically Drop a User From Your SQL Instance

Dynamically drop a user from each database on an SQL instance by their server login SID, then remove there server login as well. Plus some helpful printable information when ran.  Read more...
By Paul Andrew 2013/08/09 | Source: SQLServerCentral.com | Category: dynamic sql
Rating: (not yet rated) |  Discuss |   Briefcase | 687 reads

Finding Objects on Your SQL Instance

Find objects in any database on your SQL instance.  Read more...
By Paul Andrew 2013/07/30 | Source: SQLServerCentral.com | Category: dynamic sql
Rating: |  Discuss |   Briefcase | 1,448 reads
   Items 1 to 5 of 5