Using the the MSDB backup tables, will generate the basic disk RESTORE commands for a database. It will include the Full, differential and all associated log recovery commands for you. Run the stored proc in Query Analyser then copy/alter the output to recover your DB. Great if using EE is not your cup of tea. […]
2002-01-03
374 reads
Basic summary of all successful backups to date in descending date and ascending DB name order.
2002-01-03
540 reads
For all tables in the current database, it will script the DBCC command to reset the identity seed to 1 for all columns using them. Very handy for data migration.
2002-01-01
835 reads
Here are two stored procedures for enabling and disabling all keys (primary and foreign) for a specified database. It makes sure the database specified is not the system databases and the users session is at the DB to have its keys enables/disabled.
2001-09-19
822 reads
Here is a very basic example script for sending emails via CDONTS. This comes from the sqlmag web-site forum. Although fine, remember that it will use the local SMTP server to forward emails onto the destination user. If your servers smtp process can not reach an exchange/group-wise/other mail box on your network, then this code […]
2001-08-09
3,546 reads
By DataOnWheels
It was awesome to see the Kentucky data community come out for the first...
By Brian Kelley
Tomorrow, April 16, 2024, I will be giving another webcast; this one will be...
By Steve Jones
the wends– n. the frustration that you’re not enjoying an experience as much as...
Hello all, I am thinking of creating a "shopping cart" in our application. My...
Hello there. I have the following Pipeline I want to get the property error...
I'm installing a cluster prior to my 2019 SQL build. Failover Cluster tools...
Can I create In-Memory OLTP tables in SQL Server Express?
See possible answers