Knowledgebase

Database table mover (restore backup)
-- remove bad tableDELETE FROM [ DATABASE-NAME ].[dbo].[ TABLE-NAME ];-- CREATE new table from...

Delete all tables for a specific client
Open SQL server manager. Find DB tables.Create new query (top left).Enter following (excluding...

Delete/cleanup replication on MSSQL2000
1. In Enterprise manager: right click publication and select Delete2. In SQL Query...

Excellent SQL software
Red-Gate has some pretty good software for sql development. First is there Data Generation...

List logins with SSID
Run this on MSSQL2008 to generate a list of logins.EXEC sp_help_revloginDelete any logins...

MSSQL2008 DB mirroring
SQL Server Mirroring...

Resume suspended mirror and others
Run the following on the principal server:Select appropriate database then...ALTER DATABASE...

Articles