Wednesday, March 7, 2012

Logical File Name Change

Is there a way that we can change logical file names?In SQL2000 you can use
ALTER DATABASE
MODIFY FILE
(NAME = logical_file_name,
NEWNAME = new_logical_name)
See BOL for details
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"JI" <anonymous@.discussions.microsoft.com> wrote in message
news:935C21AE-5DD0-4FF8-9C1E-02A673930B8E@.microsoft.com...
> Is there a way that we can change logical file names?
>

No comments:

Post a Comment