Database compatibility between MSDE and SQL Server 2000

I have a database that was created in SQL Server 2000. Would there be any
issues if I used this database in MSDE? Does anyone know of any document
regarding this? All the articles I have read talk about MSDE databases being
compatible with SQL Server 2000. None of them discussed the reverse case.
Thanks in advance!
MSDE and SQL Server is the same. There are some features not available on MSDE, but I doubt you will
run into them...
http://msdn.microsoft.com/library/en...ar_ts_1cdv.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Anushree Laturkar" <anushree.laturkar@.bindview.com> wrote in message
news:ubDnKkx7EHA.2608@.TK2MSFTNGP10.phx.gbl...
>I have a database that was created in SQL Server 2000. Would there be any
> issues if I used this database in MSDE? Does anyone know of any document
> regarding this? All the articles I have read talk about MSDE databases being
> compatible with SQL Server 2000. None of them discussed the reverse case.
> Thanks in advance!
>
|||As long as you are talking about MSDE 2.0, not the MSDE 1.0 that came out
with SS 7.0.
Out of curiosity, why would you want to revert back like this? If you are
looking at a development platform, why not deploy SS Developer Edition.
Microsoft has recently dropped the price on this edition down to $50 and you
get the full Enterprise Edition for development purposes without any sort of
throttles or restrictions.
Sincerely,
Anthony Thomas

"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23tq6A8y7EHA.3236@.TK2MSFTNGP15.phx.gbl...
MSDE and SQL Server is the same. There are some features not available on
MSDE, but I doubt you will
run into them...
http://msdn.microsoft.com/library/en...ar_ts_1cdv.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Anushree Laturkar" <anushree.laturkar@.bindview.com> wrote in message
news:ubDnKkx7EHA.2608@.TK2MSFTNGP10.phx.gbl...
>I have a database that was created in SQL Server 2000. Would there be any
> issues if I used this database in MSDE? Does anyone know of any document
> regarding this? All the articles I have read talk about MSDE databases
being
> compatible with SQL Server 2000. None of them discussed the reverse case.
> Thanks in advance!
>