SQL Server Central is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
 

Choose a tag below, or browse popular content:

Administration     Lock and Connection Management     Replication     SQLInsider Scripts    
Backup / Restore     Mail     SQL 2005     T-SQL    
Data Warehouse     Maintenance and Management     SQL Server 2000     T-SQL Aids    
Index Management     Miscellaneous     SQL Server 2005    

Add a script

Popular Scripts

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: |  Discuss |  Briefcase | 5,528 reads

Audit SQL Logins - Updated

SQL Auditing - Generate a listing of the SQL logins, and the permissions for each database on a server. Update to Simon Facer's script.   Read more...
By Derrick H. 2007/11/28 | Category: Audit
Rating: |  Discuss |  Briefcase | 6,435 reads

Generate Scripts to Compare Tables

Generate the scripts that will allow you to compare tables pass/fail.  Read more...
By Absinthe 2008/02/06 | Source: SQLServerCentral.com | Category: Administration
Rating: |  Discuss |  Briefcase | 3,008 reads

SQL Server 2005 - Backup, Integrity Check and Index Optimization

Solution for Backup, Integrity Check and Index Optimization in SQL Server 2005.  Read more...
By Ola Hallengren 2008/04/15 | Source: SQLServerCentral.com | Category: Backup / Restore
Rating: |  Discuss |  Briefcase | 2,706 reads

Insert Update Stored Procedure for a table

Generic Script for Insert Update Stored Procedures  Read more...
By Prasad Bhogadi 2007/12/06 | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 7,376 reads

Backup Stored Proc

Script to backup 2000/2005 databases.  Read more...
By Scott Duncan 2008/01/17 | Source: SQLServerCentral.com | Category: Backup
Rating: |  Discuss |  Briefcase | 2,370 reads

Table Information View -- No Cursors!

Row counts and storage space information for all tables in the database.  Read more...
By RBarryYoung 2008/04/08 | Source: SQLServerCentral.com | Category: tables
Rating: |  Discuss |  Briefcase | 1,387 reads

Compare Different tables from 2 Databases

List tables that have different tables and column   Read more...
By jrtupa 2008/04/07 | Source: SQLServerCentral.com | Category: Administration
Rating: |  Discuss |  Briefcase | 1,518 reads

Find Column Usage

By kgayda 2007/10/10 | Category: Miscellaneous
Rating: |  Discuss |  Briefcase | 3,203 reads

Send SMS from a trigger

By Al Siks 2007/04/16 | Category: Miscellaneous
Rating: |  Discuss |  Briefcase | 5,047 reads

Row count and space used for all tables in database (update)

This procedure works like the sp_spaceused procedure but this one shows statistics for all tables in the selected database or for all databases (excluding tempdb and model).   Read more...
By Rafal S. 2008/05/02 | Source: SQLServerCentral.com | Category: Miscellaneous
Rating: |  Discuss |  Briefcase | 1,049 reads