Error on renaming database in SQL Server 2008 R2

Error on renaming database in SQL Server 2008 R2



use master

ALTER DATABASE OldDatabaseName SET SINGLE_USER WITH ROLLBACK IMMEDIATE    
ALTER DATABASE OldDatabaseName MODIFY NAME = [New_DatabaseName]

ALTER DATABASE New_DatabaseName SET MULTI_USER



Notes: you should use WITH ROLLBACK IMMEDIATE while altering a database that other users might be operating on, in order to ensure the integrity of these operations. But it is not really necessary when setting the database back to MULTI_USER mode again since the database is already at SINGLE_USER mode and you are the only user able to run any transactions anyway.


















Comments

Post a Comment

Popular posts from this blog

how to fetch all HTML Table Records and modify all records accordingly using jquery and Javascript

In my example, I have fetch HTML Table Records and Convert to Class List Object for C# Result: Click Here < script src = "https://ajax.googleapis.com/ajax/libs/jquery/3.6.3/jquery.min.js" ></ script > < script >   $ ( document ). ready ( function () {     // Get the table element     const table = document . getElementsByTagName ( "table" )[ 0 ];     // Get all the table rows     const rows = table . rows ;     // Create an empty array to store the table data     const data = [];     // Loop through each row and get the cell data     for ( let i = 0 ; i < rows . length ; i ++) {       const cells = rows [ i ]. cells ;       const rowData = {};       //new Columns { CharacterName = "", Char = "", Code = "", Decimal = "", Binary = "", Hex = "" },       var stringCon = "new Columns {" ;       /...
Read more

Optimize Process Speed using C#

To optimized code speed you can use System.Diagnostics  Namespace. ============================= using System; using System.Diagnostics; using System.Threading; namespace DiagnoseProcessSpeed {     internal class Program     {         static void Main()         {             Stopwatch sw = Stopwatch.StartNew(); // Start Stopwatch             for (int i = 1; i < 11; i++)             {                 System.Console.WriteLine("Loop : " + i);                 Thread.Sleep(1000);// interval for 1 seconds.             }             sw.Stop(); // End Stopwatch             //sw.Elapsed Contain Process Taking Time in Seconds             System....
Read more

how to Replace null value with 0 Using C#

how to Replace null value with 0 Using C# //here we suppose that objDataTable have data collection as table now access this //datatable object. decimal  j = 0;  j = objDataTable.Rows[0]["Qty"] ==  DBNull .Value ? 0 :  Convert .ToDecimal(objDataTable.Rows[0]["Qty"]); NOTE :- //if   DBNull.value is null  then   "0 " else  "your code here")  // ? = then // : = else Thank You [Sumit Singh Shekhawat]
Read more