Changing a db's logical file name

Good day all,
Does anyone have any ideas on how I can change the Logical File Name from
'IA_Dev_Data' to 'BDOpp_Data' for a database? If the graphic isn't visible,
I'm referring to the logical name in the File Name field on the General Tab
when viewing a database's properties in EM. We're running SQL 7.
--
Any and all contributions are greatly appreciated ...
Regards TJHi,
In SQL 2000 you can use
Alter Database YourDB
Modify File
(Name = CurrentFileName,
Newname = NewFileName)
There is no supported proper way to do this on SQL Server 7
Thanks
Hari
MCDBA
"TJ" <nospam@.nowhere.com> wrote in message
news:ubyxRbW2DHA.2868@.TK2MSFTNGP09.phx.gbl...
> Good day all,
> Does anyone have any ideas on how I can change the Logical File Name from
> 'IA_Dev_Data' to 'BDOpp_Data' for a database? If the graphic isn't
visible,
> I'm referring to the logical name in the File Name field on the General
Tab
> when viewing a database's properties in EM. We're running SQL 7.
>
>
>
> --
> Any and all contributions are greatly appreciated ...
> Regards TJ
>
>
>
>|||Thanks so much Hari. Have a good one!
"Hari" <hari_prasad_k@.hotmail.com> wrote in message
news:ueHdzbY2DHA.2604@.TK2MSFTNGP09.phx.gbl...
> Hi,
> In SQL 2000 you can use
> Alter Database YourDB
> Modify File
> (Name = CurrentFileName,
> Newname = NewFileName)
> There is no supported proper way to do this on SQL Server 7
>
> Thanks
> Hari
> MCDBA
> "TJ" <nospam@.nowhere.com> wrote in message
> news:ubyxRbW2DHA.2868@.TK2MSFTNGP09.phx.gbl...
> > Good day all,
> >
> > Does anyone have any ideas on how I can change the Logical File Name
from
> > 'IA_Dev_Data' to 'BDOpp_Data' for a database? If the graphic isn't
> visible,
> > I'm referring to the logical name in the File Name field on the General
> Tab
> > when viewing a database's properties in EM. We're running SQL 7.
> >
> >
> >
> >
> >
> >
> > --
> > Any and all contributions are greatly appreciated ...
> > Regards TJ
> >
> >
> >
> >
> >
> >
> >
>|||Will this cause any problems by not changing the name? When is this name
used?
"TJ" <nospam@.nowhere.com> wrote in message
news:uLXLuQe2DHA.1744@.TK2MSFTNGP12.phx.gbl...
> Thanks so much Hari. Have a good one!
> "Hari" <hari_prasad_k@.hotmail.com> wrote in message
> news:ueHdzbY2DHA.2604@.TK2MSFTNGP09.phx.gbl...
> > Hi,
> >
> > In SQL 2000 you can use
> >
> > Alter Database YourDB
> > Modify File
> > (Name = CurrentFileName,
> > Newname = NewFileName)
> >
> > There is no supported proper way to do this on SQL Server 7
> >
> >
> >
> > Thanks
> > Hari
> > MCDBA
> >
> > "TJ" <nospam@.nowhere.com> wrote in message
> > news:ubyxRbW2DHA.2868@.TK2MSFTNGP09.phx.gbl...
> > > Good day all,
> > >
> > > Does anyone have any ideas on how I can change the Logical File Name
> from
> > > 'IA_Dev_Data' to 'BDOpp_Data' for a database? If the graphic isn't
> > visible,
> > > I'm referring to the logical name in the File Name field on the
General
> > Tab
> > > when viewing a database's properties in EM. We're running SQL 7.
> > >
> > >
> > >
> > >
> > >
> > >
> > > --
> > > Any and all contributions are greatly appreciated ...
> > > Regards TJ
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> >
> >
>