jake levington

I understand that there is a 2GB limit in MSDE so that
databases can't be created or expanded past 2GB. However,
if the database has come from SQL Server 2000 and is over
2GB (15GB)and is for reference only, is it possible to use
within MSDE?

Thanks for your help.

greg low [mvp]

Hi Jake,

I haven't tried it but have heard from others that it will attach. However,
they had a variety of problems later. Wouldn't recommend it except to
perhaps extract some data.

HTH,

--
Greg Low [MVP]
MSDE Manager SQL Tools
http://www.whitebearconsulting.com

william \(bill\) vaughn

Or use SQLExpress which has a 4GB limit.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
http://www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________