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

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

Add a script

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

Get the all user and their server role

The script give you the list of all users and their respective Server roles  Read more...
By Mitesh Oswal 2014/04/02 | Source: SQLServerCentral.com | Category: security
Rating: (not yet rated) |  Discuss |   Briefcase | 837 reads

Get the Column level difference for 2 database

The query will help to get the column level difference for 2 database(Like Prod and Dev database). This help us to verify what are the column changes has been done in dev environment after Prod deployment.   Read more...
By Mitesh Oswal 2014/04/10 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 757 reads

Defragmentation and update statistics for all online databases

Defragment and Update Statistics.   Read more...
By Vimal Lohani 2014/03/27 | Source: SQLServerCentral.com | Category: defragmentation.
Rating: |  Discuss |   Briefcase | 1,094 reads

DBCC,Backup, Verify and create Agent Job to restore

Script to Automatically Backup, Drop and create Agent Job to restore from that backup.  Read more...
By Rob Sewell 2014/03/25 | Source: SQLServerCentral.com | Category: rationalisation
Rating: (not yet rated) |  Discuss |   Briefcase | 712 reads

Transfer users from one base to another

This script lists all users of all databases on the server.  Read more...
By Fabiano Carvalho 2014/03/31 | Source: SQLServerCentral.com
Rating: (not yet rated) |  Discuss |   Briefcase | 845 reads

Partitioned Table View

This is my View for collecting information about partitioned tables.  Read more...
By Eric Eyster 2014/03/26 | Source: SQLServerCentral.com | Category: partitioning
Rating: |  Discuss |   Briefcase | 633 reads

Script to Restore Entire database from a directory

Script to restore the entire databases from the backup directory just by passing the backup directory.  Read more...
By sathish siva 2014/03/20 | Source: SQLServerCentral.com | Category: restore
Rating: |  Discuss |   Briefcase | 1,403 reads

Script to Check the Database Backup duration

Script to Check the Database Backup duration of entire instances  Read more...
By sathish siva 2014/03/19 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 920 reads

Script to Get the Database size in GB's

Script to Get the database file size in GB  Read more...
By sathish siva 2014/03/18 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,240 reads

Script to Get the Database Restore history

Script to get the Database restore history details including with the files by which the database is restored.  Read more...
By sathish siva 2014/03/17 | Source: SQLServerCentral.com | Category: restore
Rating: |  Discuss |   Briefcase | 779 reads

Script to Get the Backup History

Script to get the database backup history on SQL Server 2000/2005/2008  Read more...
By sathish siva 2014/03/14 | Source: SQLServerCentral.com | Category: backup / recovery
Rating: |  Discuss |   Briefcase | 853 reads

Recreate Missing Log Files

To recreate log files on sql server  Read more...
By sathish siva 2014/03/13 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 762 reads

Using Seqence Container instead of Identity

This script is an example of how to use Sequence, similar to Identity.   Read more...
By Mitesh Oswal 2014/03/24 | Source: SQLServerCentral.com | Category: ssis
Rating: |  Discuss |   Briefcase | 1,043 reads

Generate merge script for all primary key tables in a database

This code generates merge scripts in the form of individual stored procedures for each table within a specified database. Once executed, simply highlight the results within the following columns altogether and past into a new window: SET_OPERATOR, AND_OPERATOR, COLUMN_SQL Enjoy  Read more...
Rating: (not yet rated) |  Discuss |   Briefcase | 829 reads

Template - Type 6 SCD Stored Procedure

Template to create a Type 6 slowly changing dimension stored procedure  Read more...
By Marie Bayer 2014/03/05 | Source: SQLServerCentral.com | Category: template
Rating: |  Discuss |   Briefcase | 1,073 reads

Calendar Table by Year

Populate a calendar table with user set interval start and end datetime values.  Read more...
By Marie Bayer 2014/03/11 | Source: SQLServerCentral.com | Category: reporting
Rating: (not yet rated) |  Discuss |   Briefcase | 826 reads

Calendar Table by Month

Populate a calendar table with user set interval start and end datetime values.  Read more...
By Marie Bayer 2014/03/10 | Source: SQLServerCentral.com | Category: reporting
Rating: |  Discuss |   Briefcase | 892 reads

Calendar Table by Day

Populate a calendar table with user set interval start and end datetime values.  Read more...
By Marie Bayer 2014/03/12 | Source: SQLServerCentral.com | Category: reporting
Rating: |  Discuss |   Briefcase | 628 reads

Calendar Table by Interval Minutes

Populate a calendar table with user set interval start and end datetime values.  Read more...
By Marie Bayer 2014/03/06 | Source: SQLServerCentral.com | Category: calendar
Rating: |  Discuss |   Briefcase | 889 reads

The dynamic unpivoter.

Have you ever wanted to dynamically unpivot a table?  Read more...
By John Corcoran 2014/03/04 | Source: SQLServerCentral.com | Category: unpivot
Rating: |  Discuss |   Briefcase | 958 reads
<< Newer    Items 21 to 40 of 2942    Older >>