Import database from source server using full and transaction log backups as recorded in msdb. Use it to import one or more databases to your development environment, to test your backups regularly or to move databases to a new server. Works on SQL 7 and SQL 2000 with native and/or LiteSpeed full backups and native […]
2007-06-06 (first published: 2005-06-29)
648 reads
This SP rebuilds and reorganizes all indexes in the specified database or all databases. You can run code or generate code. Database will be set in bulk logged mode during processing and set back to normal when finished.Different SQL Editions are handled. LOB indexes, row and page locking options, number of processors, concurrent users and […]
2007-01-30 (first published: 2007-01-03)
6,854 reads
Import database from source server using full and transaction log backups as recorded in msdb. Use it to import one or more databases to your development environment, to test your backups regularly or to move databases to a new server. To move to a new server, take a transaction log backup and put all in […]
2005-07-04 (first published: 2005-07-01)
207 reads
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Short post today. Simple query that will tell you every job that ran between...
One of my clients, Justin Williams, is a blogger. He owns a website named...
Comments posted to this topic are about the item Checking Up on Vendors, which...
Hi all, I have a task that costs me a lot of time Maybe...
Hello! I have a already created stored procedure named Membership which now is used...
Ask SSC