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

Scripts by Ryan Loftin

SQLServerCentral.com profile

   Items 1 to 3 of 3   
 

Mirror Partner Agent Job To Auto Kick Back to Primary

Query the mirror instance via agent job to auto kick back to primary. If db is in suspended state will resume mirroring.  Read more...
By Ryan Loftin 2016/01/05 | Source: SQLServerCentral.com | Category: mirroring
Rating: |  Discuss |   Briefcase | 420 reads

Failed and Successful Login Auditing Using xp_readerrorlog

Script uses undocumented extended stored procedure xp_readerrorlog to find failed logins (grouped) and last successful login  Read more...
By Ryan Loftin 2015/12/30 | Source: SQLServerCentral.com | Category: auditing
Rating: |  Discuss |   Briefcase | 920 reads

Ping Linked Servers From Agent Job

Ping your linked servers, send email if ping fails.  Read more...
By Ryan Loftin 2014/12/12 | Source: SQLServerCentral.com | Category: ping servers
Rating: |  Discuss |   Briefcase | 891 reads
   Items 1 to 3 of 3