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
Posted by Beata at 8:58 PM
Labels: , , , , , , , , , ,

1 comment:

黃家俊的部落格 said...

http://www.codeproject.com/Tips/345942/Rename-a-Database-and-its-MDF-and-LDF-files-in-SQL

September 9, 2015 at 3:50 AM

Post a Comment

Subscribe to: Post Comments (Atom)