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

Scripts by Subhash Chandra

SQLServerCentral.com profile

   Items 1 to 5 of 5   
 

Script out EXISTING database mail profile's settings

Script out EXISTING database mail profile settings  Read more...
By Subhash Chandra 2018/04/25 | Source: SQLServerCentral.com | Category: mail profile
Rating: |  Discuss |   Briefcase | 281 reads

Login restriction from selected applications and users

It will help to DBA for restrict the SQL Users login from selected applications programs and track there logins with Host name and other details  Read more...
Rating: |  Discuss |   Briefcase | 259 reads

DB Blocking Automated E-mail Alerting with Blocker SP ID & query's

It will Help DBA to monitor the instant blocking and can take the action immediately on blocker query and users.  Read more...
By Subhash Chandra 2018/04/05 | Source: SQLServerCentral.com | Category: alerting
Rating: |  Discuss |   Briefcase | 311 reads

Grant Sp_who2, & who3 proc execution without granting sysadmin access

It will help to development team to find their developed & DB server status check.  Read more...
By Subhash Chandra 2018/03/28 | Source: SQLServerCentral.com | Category: db administration
Rating: |  Discuss |   Briefcase | 261 reads

All Link servers working status check and failure alert over E-mail

This procedure will help you to automation of link server failure status check with help of SQL agent job scheduling. Job query :- exec proc_check_linked_servers 'profiler name','E-mail ID'  Read more...
By Subhash Chandra 2018/02/07 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 255 reads
   Items 1 to 5 of 5