Showing posts with label databaseany. Show all posts
Showing posts with label databaseany. Show all posts

Monday, February 13, 2012

**changing the logical name**

Hi
In SQL 2000, How can I change the logical name of a database?
Any help would be greatly appreciated.You can use sp_renamedb to change the name of the database. Another option
is to use ALTER DATABASE with MODIFY option. Check SQL Server Books Online
for exact syntax.
Anith