SQL SERVER – Rename Database to New Name Using Stored Procedure by Changing to Single User Mode | Journey to SQL Authority with Pinal Dave

In my organization we rename the database on development server when are refreshing the development server with live data. We save the old database with new name and restore the database from live with same name. If developer/Jr. DBA have not saved the SQL Script from development server, he/she can go back to old Server… Continue Reading...

Source: SQL SERVER – Rename Database to New Name Using Stored Procedure by Changing to Single User Mode | Journey to SQL Authority with Pinal Dave