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

  

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

Move DB roles

This script will script the role members for all roles on the database.  Read more...
By Shanjan Sapra 2015/02/16 | Source: SQLServerCentral.com | Category: restore
Rating: (not yet rated) |  Discuss |   Briefcase | 104 reads

Kill Processes

Never recommended but always necessary script to kill some processes  Read more...
By Oscar Cervantes 2015/02/10 | Source: SQLServerCentral.com | Category: kill processes
Rating: |  Discuss |   Briefcase | 1,332 reads

SQL Database Migration :Lower version of SQL Server to Higher version

Database Migration - Lower version of Microsoft SQL Server to Higher version of SQL Server, with complete DBA Guide with Automated Scripts and Steps.  Read more...
By Dathuraj Pasarge 2015/02/16 | Source: SQLServerCentral.com | Category: database migration
Rating: |  Discuss |   Briefcase | 1,290 reads

Quick SQL Server Configuration Summary Report

This script will detect and display a quick summary of your SQL Server installation.   Read more...
By Rudy Panigas 2015/02/11 | Source: SQLServerCentral.com | Category: configuration
Rating: |  Discuss |   Briefcase | 1,523 reads

Unpivot SQL Select Data

Stored procedure to transform a 'select' result set such that each column value is presented on a separate row.  Read more...
By Ted Tabah 2015/02/02 | Source: SQLServerCentral.com | Category: unpivot
Rating: (not yet rated) |  Discuss |   Briefcase | 1,178 reads

Users , Roles and Logins

Useful script in cases where auditors would like to know roles for each user in each database of an instance as well as the status of associated logins.  Read more...
By Kenneth Igiri 2015/02/03 | Source: SQLServerCentral.com | Category: auditing
Rating: |  Discuss |   Briefcase | 1,655 reads

Alter database owner to SA from any user details on all user databases

Alter database owner to SA from any other user details against all user databases  Read more...
By S M 2015/01/29 | Source: SQLServerCentral.com | Category: security | SQL Scripts Manager Compatible
Rating: |  Discuss |   Briefcase | 1,062 reads

Find Null values on every column

with this script you will be able to see if you have a null value on every column of your table  Read more...
By Leonardo Campos 2015/01/28 | Source: SQLServerCentral.com | Category: null
Rating: |  Discuss |   Briefcase | 1,489 reads

Update Statistics for databases where you have access

Run this stored procudure to update statistics for those SQL Server databases where you have permission  Read more...
By Christopher Petrich 2015/01/27 | Source: SQLServerCentral.com | Category: update stats
Rating: |  Discuss |   Briefcase | 800 reads

Real World: SQL Server Quick Quality Check for DBA's.

DBA SQL Instance quick quality check.  Read more...
By Randeep Singh 2015/01/22 | Source: SQLServerCentral.com | Category: dba sql instance quick quality check.
Rating: |  Discuss |   Briefcase | 2,416 reads

Calendar Table Function

This iTVF will produce a calendar table that can be used for complex date manipulation; quickly and effeciently  Read more...
By Chris Kutsch 2015/01/07 | Source: SQLServerCentral.com | Category: calendar
Rating: |  Discuss |   Briefcase | 1,832 reads

Find no of records in each table in database (against Clustered Index)

If you want to find TotalPages, Usedpages,datapages,totalspaceMB,UsedSpaceMB,DataSpaceMB then can use this query.  Read more...
By S M 2015/01/08 | Source: SQLServerCentral.com | Category: row count | SQL Scripts Manager Compatible
Rating: |  Discuss |   Briefcase | 1,139 reads

Verify Login SID and Machine SID

This script is to verify which login accounts have SID values that don’t match the correct SID values defined on the machine or in the domain.  Read more...
By S M 2015/01/12 | Source: SQLServerCentral.com | Category: sid mismatch check | SQL Scripts Manager Compatible
Rating: |  Discuss |   Briefcase | 1,106 reads

Migrate existing DB Mail Exchange Configuration with New

Sometime due to the heavy load in Exchange servers we received configuration alerts notifications and report delay and that time it is require to move to some other exchange servers to full fill the requirement during the critical periods.  Read more...
By Nitin Gupta 2015/01/13 | Source: SQLServerCentral.com | Category: dbmail
Rating: (not yet rated) |  Discuss |   Briefcase | 495 reads

Find Deny permissions on database objects

This script allows the DBA to quickly determine if a deny statement is stopping a user from accessing db objects.  Read more...
By Captain DBA 2015/01/14 | Source: SQLServerCentral.com | Category: permissions | SQL Scripts Manager Compatible
Rating: |  Discuss |   Briefcase | 659 reads

Automatic restore database to different server from backup file

if you get bunch of back up files ( full backup and transaction log backup, you need restore those database to different server, you can use my stored procedure to genereate the restore command   Read more...
By David Zhou 2015/01/15 | Source: SQLServerCentral.com | Category: restore
Rating: (not yet rated) |  Discuss |   Briefcase | 1,321 reads

Function for String Occurences Count

This function is used to get the particular string occurences count from the given input string.  Read more...
By Vignesh Arulmani 2015/01/16 | Source: SQLServerCentral.com | Category: string occurences | SQL Scripts Manager Compatible
Rating: |  Discuss |   Briefcase | 890 reads

Calculate Power - Most Advanced UOC

This function is used to calculate the actual unit of conversion for power.  Read more...
By Vignesh Arulmani 2015/01/23 | Source: SQLServerCentral.com | Category: unit of conversion
Rating: |  Discuss |   Briefcase | 695 reads

Calculate Volume - Most Advanced UOC

This function is used to calculate the actual unit of conversion for volume.  Read more...
By Vignesh Arulmani 2015/01/30 | Source: SQLServerCentral.com | Category: unit of conversion
Rating: |  Discuss |   Briefcase | 723 reads

Calculate Time - Most Advanced UOC

This function is used to calculate the actual unit of conversion for time.  Read more...
By Vignesh Arulmani 2015/01/19 | Source: SQLServerCentral.com | Category: unit of conversion
Rating: |  Discuss |   Briefcase | 840 reads
   Items 1 to 20 of 3111    Older >>
 
 
Copyright © 2002-2015 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.