usp_ToggleDatabases

usp_ToggleDatabases is a simple procedure that will switch the names of two databases.One of the main problems with using sp_renamedb to switch databases is that the procedure will wait until the database is free before the rename can be completed. If the new live database is also in use then there is a likelyhood that […]

5 (1)

2005-08-04 (first published: )

478 reads

Blogs

Containers: Create a Custom Container

By

Creating a custom container is where things get truly exciting. There’s actually a ton...

Mini-Rant: Spoofed Phone Numbers and Trust

By

I’ve seen this more and more over the last year: I receive a phone...

Speaking at SQL Saturday Dallas

By

Speaking at SQLSaturday Dallas! I’m proud to announce that I will be speaking at SQL...

Read the latest Blogs

Forums

The Change Failure Rate

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Change Failure Rate

Reporting Server

By Admingod

I have reporting server which gets replicated from other OLTP server.However, the reporting server...

FlushCache Error Message

By bobba

While analyzing an issue, I stumbled on to a "FlushCache" error message (error log). ...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers