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

Alternative for Policy Management in SQL Server

In versions prior to SQL 2008, there is no policy Management. However, we can enforce policies. The script gives an example to enforce naming standards on a stored procedure.  Read more...
By Karthik Jadav 2014/03/28 | Source: SQLServerCentral.com | Category: policy management
Rating: |  Discuss |   Briefcase | 434 reads

IndexInformation

Retrieve Index Information for all tables.  Read more...
By m mcdonald 2014/04/03 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 834 reads

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 | 858 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 | 791 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,108 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 | 722 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 | 856 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 | 648 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,423 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 | 933 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,251 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 | 788 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 | 861 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 | 766 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,052 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 | 839 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,086 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 | 833 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 | 900 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 | 639 reads
<< Newer    Items 21 to 40 of 2944    Older >>