This procedure provides you the progess of the database backup or restore. We can execute the procedure to find the remaining time for completion of the backup or restore.
2011-07-18 (first published: 2010-02-19)
2,387 reads
Consolidated script generator for multiple stored procedures (existing and/or newly created) in MS Sql Server 2000/2005/2008 at one go
2011-07-15 (first published: 2011-03-28)
2,076 reads
It creates the script for restoring your database with all the backups (full, differential and transaction log) needed.
2011-07-13 (first published: 2007-12-27)
5,027 reads
Implementing a queue table in SQL server
2011-07-12 (first published: 2011-07-01)
1,154 reads
A script to verify a database backup using T-SQL code
2011-07-11 (first published: 2011-07-02)
2,126 reads
Give information in tables such as type size and description of each of the columns
2011-07-08 (first published: 2011-07-06)
1,490 reads
This script will email info about the longest running SPID in an HTML formatted table
2011-07-07 (first published: 2011-06-27)
2,208 reads
T-SQL Script for Time Dimension Table Data: Populates Data between two dates for Reporting Solutions.
2011-07-04 (first published: 2010-06-14)
3,840 reads
A short script to backup all filegroups, for those who utilise filegroups within a database.
2011-06-29 (first published: 2010-07-20)
1,383 reads
Script to setup transactional replication with updatable subscriptions when also using mirroring
2011-06-28 (first published: 2010-06-16)
5,228 reads