Re: Upgrade from MSDE to SQL Server
From: Aaron Bertrand - MVP (aaron_at_TRASHaspfaq.com)
Date: 05/07/04
- Next message: qa: "Securing Connection string"
- Previous message: Aaron Bertrand - MVP: "Re: Field Description Won't Save in MSDE Table"
- In reply to: Narine: "Upgrade from MSDE to SQL Server"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 7 May 2004 13:36:46 -0400
If you installed SQL Server 2000, then you now have two instances: MSDE and
SQL Server 2000. I am guessing the error message is coming from the MSDE
instance.
Use Enterprise Manager or Query Analyzer locally to detach your database(s)
from MSDE, then attach them to SQL Server 2000. Make sure to update your
client applications to point to the correct instance.
-- Aaron Bertrand SQL Server MVP http://www.aspfaq.com/ "Narine" <anonymous@discussions.microsoft.com> wrote in message news:9ec701c43452$d04d3560$a001280a@phx.gbl... > I have installed MS SQL 2000 server but I am still > receiving an error about the file size not being allowed > to be greater than 2048MB on a database created with > MSDE, I already checked in Enterprise Manager and the > database is set to unlimited size. Is there a way to > upgrade the database to SQL 2000 fully?
- Next message: qa: "Securing Connection string"
- Previous message: Aaron Bertrand - MVP: "Re: Field Description Won't Save in MSDE Table"
- In reply to: Narine: "Upgrade from MSDE to SQL Server"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
