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

Scripts by Subhash Chandra

SQLServerCentral.com profile

   Items 1 to 9 of 9   
 

Prevent accidental DB drop\delete

This script trigger will help you to accidental DB drop/delete  Read more...
By Subhash Chandra 2018/11/05 | Source: SQLServerCentral.com | Category: drop
Rating: |  Discuss |   Briefcase | 322 reads

Find the memory consumetion by each database

find the Memory used by each database  Read more...
By Subhash Chandra 2018/07/17 | Source: SQLServerCentral.com | Category: memory usage
Rating: |  Discuss |   Briefcase | 450 reads

User access management on DB & object level

It will help to find and manage the users access on DB level  Read more...
Rating: |  Discuss |   Briefcase | 264 reads

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 | 480 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 | 345 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 | 440 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 | 343 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 | 303 reads
   Items 1 to 9 of 9