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 3199    Older >>
 

Conver Number to string ( exp. 9 - 0009 or 9 - 09)

This Function convert integer to string with N number of ceros to the left  Read more...
By Andrés Novelo 2015/07/22 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,014 reads

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/07/21 | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 519 reads

Monitor SQL Server and Service

To monitor SQL service and the host server is up and running, if down send e-mail to DBA  Read more...
Rating: |  Discuss |   Briefcase | 1,432 reads

Check Overdue Databases Backup List For Multiple SQL Servers

Check Overdue Backup List for Multiple SQL Servers from last 24 hrs.  Read more...
By Rahul Biswas 2015/07/17 | Source: SQLServerCentral.com | Category: overdue backup list
Rating: |  Discuss |   Briefcase | 611 reads

Productivity Keyboard Shortcuts 2

This is something i can not work without anymore  Read more...
By Emil Bialobrzeski 2015/07/13 | Source: SQLServerCentral.com | Category: tools
Rating: |  Discuss |   Briefcase | 1,449 reads

Dynamic Sudoku for 3X3

it is a 3X3 dynamic sudoku  Read more...
Rating: (not yet rated) |  Discuss |   Briefcase | 736 reads

List schemas in a database

This is an expansion of the sys.schemas table. User schemas are sorted to the top, schema type is decoded, schema authorization is included.  Read more...
By Chris Compton 2015/07/14 | Source: SQLServerCentral.com | Category: schema
Rating: |  Discuss |   Briefcase | 985 reads

Recent Restore History

This script simply returns the most recent restore information about databases for a server. Returns the destination database name, the device used to perform the restore and the restore date.  Read more...
By Nicholas Williams 2015/07/15 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 511 reads

A new set-based T-SQL solution for Sudoku puzzle

New set-based T-SQL solution for Sudoku puzzle using binary data and bitwise operations.   Read more...
By Kevin Duan 2015/07/09 | Source: SQLServerCentral.com | Category: set based
Rating: |  Discuss |   Briefcase | 1,066 reads

Adapatative Files Autogrow

Set minimal autogrow values for datafiles and logfiles depending on the file size, thresholds for all databases  Read more...
By Samuel HERVOUET 2015/07/08 | Source: SQLServerCentral.com | Category: files
Rating: |  Discuss |   Briefcase | 472 reads

Check Free Disk Space for Multiple SQL Servers

Check Free Disk Space for Multiple SQL Servers.  Read more...
Rating: |  Discuss |   Briefcase | 1,179 reads

Data Sample Scripter

Generates code for INSERTs as well as generating data form tables for INSERT. Will also find and script all dependencies recursively, present all scripts in dependency order, and generate a reverse-dependency order set of conditional DELETE statements.  Read more...
By SQLEmil 2015/07/06 | Source: SQLServerCentral.com | Category: unit testing
Rating: (not yet rated) |  Discuss |   Briefcase | 832 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: backup
Rating: |  Discuss |   Briefcase | 418 reads

Move database files to another Drive

This script either generates or execute statements to SQL data and log files from C:\ to D:\  Read more...
By Jefferson Elias 2015/07/01 | Source: SQLServerCentral.com | Category: admninistration
Rating: |  Discuss |   Briefcase | 1,054 reads

Script to estimate the Size of log backups

We have an environment where we constantly need to estimate the size of log backups(.Trn file size). I use this script to achieve it.   Read more...
Rating: (not yet rated) |  Discuss |   Briefcase | 773 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,177 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 | 98 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 | 784 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,122 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,588 reads
<< Newer    Items 21 to 40 of 3199    Older >>