SQL Server Central: Scripts tagged SQL Server 2005, Management

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>

SQL Server Central is supported by Red Gate Software Ltd.

Log in :: Register :: Not logged in

Home Articles Editorials Forums Scripts Blogs QotD SQL Jobs Training Authors About us Contact us Newsletters Advertise Write for us

Scripts with tags SQL Server 2005, Management

Search for any content tagged SQL Server 2005 & Management

Add a script

Items 1 to 4 of 4

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 2008/11/12 | Source: SQLServerCentral.com | Category: SQL 2005

Rating: (not yet rated) |

Briefcase | 40 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 S. 2008/04/14 | Source: SQLServerCentral.com | Category: Miscellaneous

Rating:

|

Briefcase | 1,702 reads

Parse the dependency chain of an object

Parses up & down the dependency chain of an object Read more...

By Jesse McLain 2008/02/26 | Source: SQLServerCentral.com | Category: T-SQL

Rating:

|

Briefcase | 999 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 2008/02/11 | Source: SQLServerCentral.com | Category: Administration

Rating:

|

Briefcase | 10,500 reads

Items 1 to 4 of 4