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/09/04 | Source: SQLServerCentral.com | Category: dynamic sql
Rating: |  Discuss |   Briefcase | 1,476 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,316 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 | 4,013 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 | 698 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,460 reads
   Items 1 to 5 of 5