Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts by S M

SQLServerCentral.com profile

   Items 1 to 20 of 38    Older >>
 

Setup Alerts for SQL Replication

If you want to monitor few specific alerts for SQL Replication (Merge and Transnational), you can may consider adding these 14 alerts.  Read more...
By S M 2015/06/16 | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 34 reads

Delete Backup Files From Default Backup Location

IF you have need to schedule job to cleanup backup files older than N days, you can use my written script.  Read more...
By S M 2015/07/02 | Source: SQLServerCentral.com | Category: sql backup - cleanup
Rating: (not yet rated) |  Discuss |   Briefcase | 330 reads

Disk Free Space Check

IF you have a requirement to check disk free space and want to report to the team using email, can use my script  Read more...
By S M 2015/06/17 | Source: SQLServerCentral.com | Category: dbmail
Rating: |  Discuss |   Briefcase | 1,082 reads

Disk Free Space Check

IF you have a requirement to check disk free space and want to report to the team using email, can use my script  Read more...
By S M 2015/06/03 | Source: SQLServerCentral.com | Category: dbmail
Rating: |  Discuss |   Briefcase | 68 reads

Backup Growth Trend Check

-- Backup Growth Trend Check To Understand how much disk space you need in future  Read more...
By S M 2015/06/23 | Source: SQLServerCentral.com | Category: sql server bkp growth trend check
Rating: |  Discuss |   Briefcase | 704 reads

Copy Backup Files to Remote Shared Location & Delete them periodically

If you have a requirement where you need to copy all your backup files to any remote shared location from your local folder/drive and after that you need to do a periodic cleanup of the backup files, you can use my script.  Read more...
By S M 2015/06/18 | Source: SQLServerCentral.com | Category: sql server backup
Rating: |  Discuss |   Briefcase | 1,013 reads

Standardizing DBMAIL Profile & Account Setup for Notification

If you have a requirement to setup with a default global dbmail profile and account you can use my script.  Read more...
By S M 2015/06/16 | Source: SQLServerCentral.com | Category: sql server mail
Rating: |  Discuss |   Briefcase | 770 reads

Check Up Size Of Each Folder In a Path

If you have any requirement to check the size of each sub-folders in a path, you can use my script.  Read more...
By S M 2015/06/11 | Source: SQLServerCentral.com | Category: sql directory size
Rating: |  Discuss |   Briefcase | 938 reads

Execute All .SQL Script easily.

If you have a requirement to create Proc/Tables, etc to a SQL Server taking .SQL scripts from a central location (UNC), then you can use my script.  Read more...
By S M 2015/06/10 | Source: SQLServerCentral.com | Category: sql script- automation.
Rating: |  Discuss |   Briefcase | 1,254 reads

Complete Details About Backups Taken a Day Ago

Complete Details About Backups Taken a Day Ago.  Read more...
By S M 2015/06/05 | Source: SQLServerCentral.com | Category: sql server backup
Rating: |  Discuss |   Briefcase | 770 reads

Report Alerts from SQL ErrorLog

Sends Back Critical Alerts from ErrorLog occurred in the last 24 Hrs. You can even modify the data [Check @start and change the value]  Read more...
By S M 2015/06/02 | Source: SQLServerCentral.com | Category: sql errorlog
Rating: |  Discuss |   Briefcase | 1,256 reads

Query to find size of each disk file in a location

Query to find size of each file in a location  Read more...
By S M 2015/05/26 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 848 reads

Delete all files from a folder using xp_cmdshell

Delete all files from a folder using xp_cmdshell  Read more...
Rating: |  Discuss |   Briefcase | 741 reads

Taking Backup Of All DBs

Wrote the script to take compressed backup with combining many other features.  Read more...
By S M 2015/05/18 | Source: SQLServerCentral.com | Category: sql backup script
Rating: |  Discuss |   Briefcase | 790 reads

Query to find the Job Output file location at each job step.

Query to find the Job Output file location at each job step. This helps if you want to find out the location of each output file of jobs to find out whether those are going to the right location.  Read more...
Rating: |  Discuss |   Briefcase | 679 reads

Extract default & Named Instance from @@servername

Extract default & Named Instance from @@servername. Print all characters before and after \ to find default and named instance name.  Read more...
Rating: |  Discuss |   Briefcase | 831 reads

Check existence of a database

Check Status of a database. It will loop through all databases and will print message if the db is present.  Read more...
Rating: |  Discuss |   Briefcase | 1,077 reads

READ Data from default Trace

READ Data from default Trace to know when the objects are altered. If no database name is provided, it will run through all the databases.  Read more...
Rating: |  Discuss |   Briefcase | 850 reads

Use Of Cursor Vs Simple While Loop

You can eliminate CURSOR many a places using WHILE Loop.  Read more...
Rating: |  Discuss |   Briefcase | 2,637 reads

Generate password using PowerShell

If you want to generate temporary passwords, can use my script.  Read more...
Rating: |  Discuss |   Briefcase | 837 reads
   Items 1 to 20 of 38    Older >>