SQLUSA

Microsoft SQL Server 2000

Best Practices

 

How to rename a database?

 

This function is not available in Enterprise Manager.

Use system stored proc from query analyzer or osql:

sp_renamedb OldDBName, NewDBName

 

 

Best in the World in SQL Server Training
 
SQLUSA.com Home Page