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?

--sharif

Re: Logical Name

Sharif Islam (mislam@spam.uiuc.edu) writes:
> 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/prodtechnol/sql/2005/downlo ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books .mspx