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 different types of backups avaialabe in sql server? : Sql server database administration
What is the use of =,==,=== operators?
Is sql server is free?
What is apply operator in sql?
How to loop through returning rows?
How to rebuild master databse?
Where is localdb stored?
Explain what is raid and what are different types of raid levels?
How to connect ms access to sql servers through odbc?
How do I schedule a sql server profiler trace?
What is the importance of concurrency control?
How do indexes help, types?
What is single-user mode and what are the steps you should follow to start sql server in single-user mode?
What are ddl triggers and types of ddl trigger?
What is the difference between a stored procedure and a user defined function?
