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

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Add a script

<< Newer    Items 21 to 40 of 3183    Older >>
 

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 | 64 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 | 690 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,000 reads

Email SP Results

Will take a stored procedure and email the results in a dynamically generated embedded HTML table or as an attachment.   Read more...
By Nicholas Williams 2015/06/12 | Source: SQLServerCentral.com | Category: email
Rating: |  Discuss |   Briefcase | 1,380 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 | 758 reads

Backup All User Databases

Backup all user databases on a SQL Server instance.  Read more...
By Greg Roberts 2015/06/15 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 654 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 | 930 reads

Magic 8 Ball

This script creates a stored procedure that mimics a Magic 8 Ball  Read more...
By Carlton Ramsey 2015/06/09 | Source: SQLServerCentral.com | Category: fun
Rating: |  Discuss |   Briefcase | 1,452 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,236 reads

Count character matches with DATALENGTH function

https://github.com/ktaranov/sqlserver-kit/blob/master/Scripts/Count%20character%20matches.sql  Read more...
By Konstantin Taranov 2015/06/08 | Source: SQLServerCentral.com | Category: string functions
Rating: (not yet rated) |  Discuss |   Briefcase | 915 reads

PatReplace8K

This inline table valued function takes three parameters: @String, @Pattern and @Replace. It located the @pattern in @string and replaces it with @replace.   Read more...
By Alan Burstein 2015/06/29 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 679 reads

Dynamic sql procedure for bulk insert

https://github.com/ktaranov/sqlserver-kit/blob/master/Stored_Procedure/usp_BulkUpload.sql  Read more...
By Konstantin Taranov 2015/06/03 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 1,321 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 | 761 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,241 reads

Query Performance Report

The procedure created by this script rolls up the collected query execution statistics and groups them daily by the plan hash value.  Read more...
By Steven Guest 2015/06/01 | Source: SQLServerCentral.com | Category: performance
Rating: |  Discuss |   Briefcase | 2,142 reads

Standardize Object Names

Rename all database objects to use a standardize naming convention.  Read more...
By Cody Allen 2015/05/25 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,149 reads

Store a file & Retrive it in Sql Server

Store a file & Retrive it in Sql Server  Read more...
By Vimal Lohani 2015/05/29 | Source: SQLServerCentral.com | Category: binary data
Rating: |  Discuss |   Briefcase | 1,284 reads

Dynamic sql for convert SQL statement to txt/csv file

Github link: https://github.com/ktaranov/sqlserver-kit/blob/master/Stored_Procedure/usp_bcpUnloadSelect.sql Quick export to flat file. Before use please enable xp_cmdshell.  Read more...
Rating: |  Discuss |   Briefcase | 1,488 reads

Detach & Attach Procedure

For successful run, Your SQL Server service account should have permission to old location & new location  Read more...
By Vimal Lohani 2015/05/27 | Source: SQLServerCentral.com | Category: detach database
Rating: |  Discuss |   Briefcase | 830 reads
<< Newer    Items 21 to 40 of 3183    Older >>