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

Sorting in Stored Procedures – Food for Thought

By

We know that sorting can be one of the most expensive things in an...

Insperation

By

Inspiration: The process of being mentally stimulated to do or feel something, especially to...

Trace Query in Extended Events

By

The ability to quickly and easily trace a query is important to database professionals....

Read the latest Blogs

Forums

Replication causing log bloating

By tarr94

Hello, We've had a replication process in place for several years.  It seems like...

How to import Excel with XML

By itmasterw 60042

Hi, I have an Excel sheet that I have to import into SQL Server....

Recursive CTE - Batches

By koti.raavi

Hi Folks I'm trying to group rows into batch and adding batch to query...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers