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
Explain primary key?
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
Why do we use stored procedures in sql server?
Describe the functionalities that views support.
What is the use of sign function?
How many types of functions are there in sql server?
How can you check the level of fragmentation on a table?
Write a SQL command to insert and update only a particular field?
what is a schema in sql server 2005? : Sql server database administration
What is 2nf normalization?
Write a sql query to sort on different column name according to the parameters passed in the function?
Define full outer join?
What are the different acid properties?
What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?
How can you check the version of sql server?
