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

Script move of DB files from one location to another

Generates Scripts to move DB files from one location to another SQL and powershell scripts  Read more...
By Greg Ryan 2014/04/15 | Source: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 1,327 reads

Find dependencies between field and sp/function

This script shows the stored procedures and functions affected by field name change in a table.  Read more...
By Raymond Xie 2014/04/09 | Source: SQLServerCentral.com | Category: dependencies
Rating: (not yet rated) |  Discuss |   Briefcase | 679 reads

Insert Generator - Stored Procedure

Stored procedure to generate an insert script for a table.  Read more...
By Nick Greene 2014/04/14 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 1,323 reads

Quick snapshot

Script enables a quick creation of snapshots for databases  Read more...
By Igor Micev 2014/04/04 | Source: SQLServerCentral.com | Category: snapshot
Rating: |  Discuss |   Briefcase | 786 reads

Identify Column Data Types

Use the following queries to list a result set of all column data types to any specified database. In the 2nd query, you will see a result set based on all text based data type columns in your database (XML data type not included). Modify accordingly.  Read more...
By Rich Yarger 2014/04/07 | Source: SQLServerCentral.com | Category: data types
Rating: |  Discuss |   Briefcase | 961 reads

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 | 436 reads

IndexInformation

Retrieve Index Information for all tables.  Read more...
By m mcdonald 2014/04/03 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 840 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 | 874 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 | 813 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,117 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 | 731 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 | 861 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 | 656 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,432 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 | 941 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,259 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 | 794 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 | 870 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 | 772 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,061 reads
<< Newer    Items 21 to 40 of 2949    Older >>