<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>
Log in
::
Register
::
Not logged in
Search:
Home
Articles
Editorials
Forums
Scripts
Blogs
QotD
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Advertise
Write for us
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
Backup SQL Server Database with Move/Copy File
Read more...
By
MD
2007/09/14
|
Category:
Backup / Restore
Rating:
|
Discuss
|
Briefcase
|
7,165 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
Monitor Database Growth
Read more...
By
Brandie Tarvin
2007/05/16
|
Category:
Maintenance and Management
Rating:
|
Discuss
|
Briefcase
|
7,054 reads
usp_KillConnections
Read more...
By
Antonio
0001/01/01
|
Category:
Lock and Connection Management
Rating:
|
Discuss
|
Briefcase
|
5,105 reads
Auto Auditing on Tables
Read more...
By
Christopher Stobbs
2007/10/03
|
Category:
Maintenance and Management
Rating:
|
Discuss
|
Briefcase
|
5,101 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
Automatically Restores All database ".BAK" Files
Restore Many Backup FIles
Read more...
By
Lester Policarpio
2007/11/08
|
Source:
SQLServerCentral.com
|
Category:
Backup / Restore
Rating:
|
Discuss
|
Briefcase
|
4,347 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
Automate Scripting with SQL Scripter
Read more...
By
kwittmer
2007/10/12
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
4,629 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
Read more...
By
kgayda
2007/10/10
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
3,203 reads
Get the list of permissions of database object
Read more...
By
Deepthi Viswanathan Nair
2007/09/28
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
3,751 reads
Send SMS from a trigger
Read more...
By
Al Siks
2007/04/16
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
5,047 reads
Who's Blocking
Read more...
By
Eric Wahner
2007/04/19
|
Category:
Lock and Connection Management
Rating:
|
Discuss
|
Briefcase
|
5,136 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
Get all user def table info with rowcount and size
Read more...
By
Mohit Nayyar
2007/11/19
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
3,091 reads
Copyright © 2002-2008 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use
