SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Scripts with tag Management Rss

Search for any content tagged management

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 5 of 5   

Reindex all indexes online or offline depending on day of week.

This script will reindex (online) any index eligible to be reindexed online. Accepts a day of week parameter for full offline reindexing.   Read more...
By Kenneth Singer 2011/04/18 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 4,576 reads

Clear database - delete all records from a database (updated)

The procedure below deletes all records from the specified database's(except master, model, msdb and tempdb) tables (except those from the schema 'sys').  Read more...
By Rafal Skotak 2011/12/09 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 4,085 reads

Shrink all databases

Procedure changes all databases' recovery mode to simple and shrinks them all (or at least it tries to).  Read more...
By Rafal Skotak 2012/03/07 | Source: SQLServerCentral.com | Category: backup and restore
Rating: |  Discuss |   Briefcase | 3,858 reads

Parse the dependency chain of an object

Parses up & down the dependency chain of an object.  Read more...
By Jesse McLain 2011/09/20 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,226 reads

Get record count for a specific database

This will sum all of the records of a specified database, excluding the 'sysdiagrams' table.  Read more...
By James Rea 2013/10/23 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 19,448 reads
   Items 1 to 5 of 5