run sql server 2000 as sql server 7

Hi
I want to downgrade a sql server from v2000 to v7 for compatibility
reasons. How would I go about doing this?
Many Thanks
IainIn EM, right click on the database you want to change, choose properties,
then the options tab, at the bottom of the dialog, there is a compatability
option, set that to 7.0
"Iain A. Mcleod" <mcleodia@.dcs.gla.ac.uk> wrote in message
news:usdnofIqEHA.1308@.TK2MSFTNGP14.phx.gbl...
> Hi
> I want to downgrade a sql server from v2000 to v7 for compatibility
> reasons. How would I go about doing this?
> Many Thanks
> Iain
>|||Ahh, I was looking under the options for a server not for a database!!!
Does that mean you can run one DB as v7 and one as v2000?
If so: kewl!
Thanks and have a nice weekend!
IM
"DWinter" <dwinter@.attbi.com> wrote in message
news:uXhBNcJqEHA.348@.TK2MSFTNGP15.phx.gbl...
> In EM, right click on the database you want to change, choose properties,
> then the options tab, at the bottom of the dialog, there is a
compatability
> option, set that to 7.0
> "Iain A. Mcleod" <mcleodia@.dcs.gla.ac.uk> wrote in message
> news:usdnofIqEHA.1308@.TK2MSFTNGP14.phx.gbl...
> > Hi
> >
> > I want to downgrade a sql server from v2000 to v7 for compatibility
> > reasons. How would I go about doing this?
> >
> > Many Thanks
> > Iain
> >
> >
>|||Yep
"Iain A. Mcleod" <mcleodia@.dcs.gla.ac.uk> wrote in message
news:u0rbkfJqEHA.3668@.TK2MSFTNGP15.phx.gbl...
> Ahh, I was looking under the options for a server not for a database!!!
> Does that mean you can run one DB as v7 and one as v2000?
> If so: kewl!
> Thanks and have a nice weekend!
> IM
> "DWinter" <dwinter@.attbi.com> wrote in message
> news:uXhBNcJqEHA.348@.TK2MSFTNGP15.phx.gbl...
> > In EM, right click on the database you want to change, choose
properties,
> > then the options tab, at the bottom of the dialog, there is a
> compatability
> > option, set that to 7.0
> >
> > "Iain A. Mcleod" <mcleodia@.dcs.gla.ac.uk> wrote in message
> > news:usdnofIqEHA.1308@.TK2MSFTNGP14.phx.gbl...
> > > Hi
> > >
> > > I want to downgrade a sql server from v2000 to v7 for compatibility
> > > reasons. How would I go about doing this?
> > >
> > > Many Thanks
> > > Iain
> > >
> > >
> >
> >
>sql