Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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 81 to 100 of 3273    Older >>
 

Check SQL DB backups details remotely by PowerShell

Check SQL DB backups details remotely by PowerShell  Read more...
By Raushan 2015/08/11 | Source: SQLServerCentral.com | Category: sql powershell
Rating: |  Discuss |   Briefcase | 1,186 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: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 1,136 reads

Random Data Generator

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

Display Transaction Log Size

Stored procedure to display transaction log size for select databases.  Read more...
By Peter Wehner 2015/08/03 | Source: SQLServerCentral.com | Category: transaction log
Rating: |  Discuss |   Briefcase | 1,246 reads

Anonymous reality!

Create anonymous test data using real values. No more Mickey Mouse and Paul McCartney!   Read more...
By John Fielding 2015/08/07 | Source: SQLServerCentral.com | Category: test data
Rating: |  Discuss |   Briefcase | 1,115 reads

Compare hotfix

Easy way to compare hotfix  Read more...
By Mashrur Shuvo 2015/08/04 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 638 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/08/05 | Source: SQLServerCentral.com | Category: sql restore
Rating: |  Discuss |   Briefcase | 1,646 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/08/06 | Source: SQLServerCentral.com | Category: triggers
Rating: |  Discuss |   Briefcase | 739 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: SQLServerCentral.com | Category: job dependencies
Rating: |  Discuss |   Briefcase | 1,096 reads

Get user table indexes, size and column order

get user table indexes, size and column order  Read more...
By Perry Whittle 2015/10/08 | Source: SQLServerCentral.com | Category: index size
Rating: |  Discuss |   Briefcase | 965 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: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 624 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: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 1,170 reads

When server was rebooted

Find out when your server was rebooted.  Read more...
By Mashrur Shuvo 2015/07/24 | Source: SQLServerCentral.com | Category: last reboot time
Rating: |  Discuss |   Briefcase | 1,553 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...
By Jorge Solorzano 2015/07/28 | Source: SQLServerCentral.com | Category: backup compression
Rating: (not yet rated) |  Discuss |   Briefcase | 717 reads

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,223 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 | 764 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,870 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 | 729 reads

Productivity Keyboard Shortcuts 2

This is something i can not work without anymore  Read more...
By Emil Bialobrzeski 2015/10/26 | Source: SQLServerCentral.com | Category: tools
Rating: |  Discuss |   Briefcase | 2,840 reads

Dynamic Sudoku for 3X3

it is a 3X3 dynamic sudoku  Read more...
Rating: (not yet rated) |  Discuss |   Briefcase | 919 reads
<< Newer    Items 81 to 100 of 3273    Older >>