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 the difference between function and stored procedure?
What is data set in report?
Explain transaction server isolation?
What is primary key index?
What is PROJECTION Operation?
What is cross join in sql server joins?
What is identity?
How does normalization work?
Explain what are commit and rollback in sql?
What is hot add cpu in sql server 2008?
List the different types of joins?
Tell me what are the advantages of using stored procedures?
What is the size of transaction log file?
in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it
what is blocking? : Sql server database administration
