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

   Items 1 to 20 of 3199    Older >>

Drive Space

Combine Drive Space report for all Servers 
By Mashrur Shuvo 2015/07/27 | Source: | Category: power shell
Rating: (not yet rated) |  Discuss |   Briefcase | 73 reads

Filestream and FileTable Implementation SQL Server 2012.

In this article, I would like to demonstrate about Filestream and FileTable implementation in SQL Server 2012.  Read more...
By Randeep Singh 2015/07/24 | Source: | Category: filestream
Rating: |  Discuss |   Briefcase | 51 reads

Stored Procedure to export report output to a file to any location

I've created a Stored Procedure that allows for any deployed (SSRS) report to be exported to any location in an available file output format. Requires an rss file (VB) and xp_cmdshell enabled on the SQL Server.   Read more...
By Will Beaton 2015/07/23 | Source: | Category: reporting services (ssrs)
Rating: (not yet rated) |  Discuss |   Briefcase | 115 reads

Get file sizes of database files and free space on disk

Reports on the data and log file sizes and space used within files for each database on a servers. It also includes the free space on the drive where the file is located.  Read more...
By Jonathan Roberts 2015/07/23 | Source: | Category: drive space
Rating: (not yet rated) |  Discuss |   Briefcase | 152 reads

Parse list of names from Outlook

This script will parse a list of names copied from the To box of an Outlook email.  Read more...
By Noel Scheaffer 2015/07/20 | Source: | Category: outlook
Rating: |  Discuss |   Briefcase | 79 reads

Executing Process Details

Script identifies running processes, blocking, waits, and duration 
By Chris Kutsch 2015/07/16 | Source: | Category: blocking
Rating: (not yet rated) |  Discuss |   Briefcase | 172 reads

SQL to APS Automation

This script was designed to help make importing data from any SQL2008+ database to an APS much easier.   Read more...
By Alain Dormehl 2015/07/14 | Source: | Category: aps
Rating: (not yet rated) |  Discuss |   Briefcase | 62 reads

Check SQL DB backups details remotely by PowerShell

Check SQL DB backups details remotely by PowerShell 
By Raushan 2015/07/13 | Source: | Category: sql powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 87 reads

Powershell Script To Check the SQL Jobs Status remotely

Powershell Script To Check the SQL Jobs Status remotely  Read more...
By Raushan 2015/07/30 | Source: | Category: powershell
Rating: |  Discuss |   Briefcase | 729 reads

Random Data Generator

A query to generate random values for several different data types.  Read more...
By Peter Wehner 2015/07/31 | Source: | Category: random number
Rating: |  Discuss |   Briefcase | 630 reads

Display Transaction Log Size

Stored procedure to display transaction log size for select databases.  Read more...
By Peter Wehner 2015/07/12 | Source: | Category: transaction log
Rating: |  Discuss |   Briefcase | 145 reads

Anonymous reality!

Create anonymous test data using real values. No more Mickey Mouse and Paul McCartney!   Read more...
By John Fielding 2015/07/10 | Source: | Category: test data
Rating: (not yet rated) |  Discuss |   Briefcase | 76 reads

Compare hotfix

Easy way to compare hotfix 
By Mashrur Shuvo 2015/07/08 | Source: | Category: powershell
Rating: |  Discuss |   Briefcase | 53 reads

Kill all USer Sessions before starting to restore a Database

If you have a requirement to Kill all USer Sessions before starting to restore a Database, you may use this script  Read more...
By S M 2015/07/08 | Source: | Category: sql restore
Rating: |  Discuss |   Briefcase | 180 reads

List Out All User Defined Triggers

List Out All User Defined Triggers, along with the database where the triggers are disabled. is_ms_shipped = 1 denotes that its an user written trigger.  Read more...
By S M 2015/07/07 | Source: | Category: triggers
Rating: |  Discuss |   Briefcase | 80 reads

List Job Dependencies

A Stored Procedure that lists all Jobs that target a database and the job dependencies  Read more...
By Jamie Ingram 2015/07/29 | Source: | Category: job dependencies
Rating: |  Discuss |   Briefcase | 758 reads

Cash Payments By Denomination

Will calculate min number of each denomination needed to pay a group of cash employees.   Read more...
By John Fielding 2015/07/20 | Source:
Rating: |  Discuss |   Briefcase | 520 reads

DB Integrity & Backup Report

This script returns the date for the most recent log/full backups and checks if a DBCC CHECKDB has ran within a week.  Read more...
By Nicholas Williams 2015/07/23 | Source: | Category: backup
Rating: |  Discuss |   Briefcase | 821 reads

When server was rebooted

Find out when your server was rebooted. 
By Mashrur Shuvo 2015/07/24 | Source: | Category: last reboot time
Rating: |  Discuss |   Briefcase | 1,059 reads

SQL Backups Compression Archive

This script takes the last full backup includes diff and logs backups until the next full backup in one file.  Read more...
Rating: (not yet rated) |  Discuss |   Briefcase | 520 reads
   Items 1 to 20 of 3199    Older >>