This topic explains the log shipping if the primary database is suspected or corrupted and how you can convert the secondary database into primary database.
2012-04-27 (first published: 2012-03-31)
999 reads
Are you trying to determine the gaps in a numerical sequence?
2012-04-26 (first published: 2012-04-02)
1,021 reads
How to display data from 1-to-many in a single record!
2012-04-25 (first published: 2012-04-02)
2,239 reads
This script lists all of the SQL logins with their password policy
2012-04-24 (first published: 2012-03-30)
1,838 reads
This script will list the operators that have jobs
that are configured to notify them with alerts.
2012-04-23 (first published: 2012-03-29)
955 reads
The scripts provided below will show you the "Recovery Mode (Model)" for any given database
2012-04-19 (first published: 2008-03-18)
1,989 reads
Procedure to find any object such as table/stored procedure by its name, or find for ant text inside stored procedures, functions.
2012-04-18 (first published: 2008-05-28)
2,947 reads
Converts a binary SID to string format.
2012-04-17 (first published: 2008-02-15)
7,209 reads
A script to check the owners, collations and backups on the server.
2012-04-16 (first published: 2007-10-19)
2,627 reads
SQL script to print table names and their indexes.
2012-04-13 (first published: 2007-10-19)
3,381 reads