Logical Name

Hi,
I want to change the logical name of the database. My database name and
.MDF has the same name, but the logical name is different. Will
changing it impact anything?

--sharifSharif Islam (mislam@.spam.uiuc.edu) writes:

Quote:

Originally Posted by

I want to change the logical name of the database. My database name and
.MDF has the same name, but the logical name is different. Will
changing it impact anything?

Very little. There are a few places where the logical name is used,
DBCC SHRINKFILE and RESTORE WITH MOVE are two that comes to mind. If
you happen to have any such scripts they would break.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx