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
Can you please explain the difference between primary keys and foreign keys?
Does full backup break log chain?
What is coalesce and check constraint in sql server?
What is a cube? : sql server analysis services, ssas
Explain what is meant by replication of database?
Explain temporary table vs table variable by using cursor alternative?
What is ems sql management studio? : sql server management studio
What options are there to delete rows on the publisher and not on the subscriber? : sql server replication
How can delete duplicate records in cte in sql server?
What are the limitations/drawbacks or ssrs 2008 r2?
How do triggers work?
what method you can use to reduce the overhead of Reporting Services data sources?
Define indexes?
What is nonclustered index on computed columns?
How do you check sql server is up and running?
