Wednesday, March 21, 2012

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
Iain
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
>
|||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...
>
|||Yep
"Iain A. Mcleod" <mcleodia@.dcs.gla.ac.uk> wrote in message
news:u0rbkfJqEHA.3668@.TK2MSFTNGP15.phx.gbl...[vbcol=seagreen]
> 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...
properties,
> compatability
>

No comments:

Post a Comment