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!
hi Anushree,
"Anushree Laturkar" <anushree.laturkar@.bindview.com> ha scritto nel
messaggio news:%23WE5kkx7EHA.3504@.TK2MSFTNGP12.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!
MSDE 2000 and SQL Server 2000 databases are compatible as the engine is the
same.. MSDE only has "added" features in the Storage Engine regarding checks
for datab files not exceeding 2gb upper limit
but the core architechture is the same, so you can move users SQL Server
2000 databases to MSDE 2000 and vice versa..
the same applied service pack level is appreciated
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply