Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / babuli
To rename a SQL database follow the these seps:
1. Alter database to single user mode. So that all the
active connection will be terminated. (Database properties
-> options > single usermode)
2. Then rename the database using sp_renamedb oldname, newname
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Do you know what is difference between stored procedure and user defined function?
What is the server name in sql server?
If a table does not have a unique index, can a cursor be opened on it?
What are the advantages of user defined function?
What is a partition key?
How to search for a string in all stored procedure in sql server?
What is the purpose of update statistics and scope_identity() function?
How can sql server instances be hidden?
How to sort query output in descending order in ms sql server?
How to join two tables in a single query in ms sql server?
If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?
Explain how to send email from sql database?
What is identity?
What is dynamic cursor in SQL SERVER?
Define outer join in sql server joins?
