Tuesday, November 22, 2005

SQL Server 2000: change database name

To change the database name, make sure you close Enterprise Manager. Using SQL Query Analyzer, run the following command:

alter database EXISTING_DATABASE_NAME modify name = NEW_DATABASE_NAME

1 comment:

purna sekhar said...

hi,
very nice query gave me.
thanks,thanks a lot.

thanks & regards

purna sekhar