How to change Database name in SQL Server?

Posted by Raja on 9/8/2008 | Category: Sql Server Interview questions | Views: 18865

Post |

Interview FAQs |

Exclusive Questions |

Interview Home

Answer:

Use following code

Supported in SQL Server 2000 and 2005
exec sp_renamedb "test", "test1"

Supported in SQL Server 2005 and later version
ALTER Database "test1" Modify Name="test"

Asked In: Microsoft | Alert Moderator

Bookmark It

< Previous : How to read entire stream contents?

Next > : How to sort an array into descending order?

Comments or Responses

More Interview Questions by Raja

How to sort an array into descending order?
How to convert a sentence into Title Case (Capitalize first character ...
How to convert an ArrayList into an Array?
How to convert an Array into an ArrayList?
How to get the authentication mode from web.config file programmatical ...
How to clear the last error occured in the application?
How to retrieve the last error occured in the application?
How to load a user control dynamically in runtime?

Latest Interview Questions

Difference between DropDownList.Items.Add and DropDownList.Items.Inser ...
Difference between classes and structures?
What is the purpose of connection pooling in ADO.NET?
What’s the difference between // comments, /* */ comments and /// comm ...
what is the diff between a HAVING CLAUSE and a WHERE CLAUSE?
How many types of cookies are there in ASP.NET ?
Types of Errors ?
What event handlers can I include in Global.asax?
More ...