Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts by Mark Huber

SQLServerCentral.com profile

   Items 1 to 4 of 4   
 

Recompile All Databases stored Procedures

When code is getting stall, sometimes the execution plans are point to the wrong or out dated or old objects. You would need to recompile all the stored procedures  Read more...
By Mark Huber 2016/10/14 | Source: SQLServerCentral.com | Category: recompile
Rating: |  Discuss |   Briefcase | 524 reads

Get Server version Info

Yet another Script To get Sql server version Info. Run From Central Management server to get all your environment servers  Read more...
By Mark Huber 2015/09/29 | Source: SQLServerCentral.com | Category: version
Rating: |  Discuss |   Briefcase | 1,502 reads

Ping Linked servers

This script will ping the linked server and see if there alive  Read more...
By Mark Huber 2011/11/02 | Source: SQLServerCentral.com | Category: linked servers
Rating: |  Discuss |   Briefcase | 1,540 reads

Updating Datbase Mail Exchange Server

Problem: We are replaceing our exchange server with a new one all DBMAILs on all server use the old one   Read more...
By Mark Huber 2009/07/27 | Source: SQLServerCentral.com | Category: database mail
Rating: |  Discuss |   Briefcase | 476 reads
   Items 1 to 4 of 4