Peter wrote:
> Are there any difference between upgrading from SQL Server 6.5 to
> MSDE 2000 and SQL Server 6.5 to SQL Server 2000? Is there any special
> instruction to upgrade from SQL Server 6.5 to MSDE 2000 comparing to
> from SQL Server 7?

"Andrea Montanari" wrote:

> hi Peter,
> Peter wrote:
> > Are there any difference between upgrading from SQL Server 6.5 to
> > MSDE 2000 and SQL Server 6.5 to SQL Server 2000? Is there any special
> > instruction to upgrade from SQL Server 6.5 to MSDE 2000 comparing to
> > from SQL Server 7?
>
> AFAIK, the MSDE setup is only able to upgrade existing MSDE 1.0 (based on
> SQL Server 7.0 code base) instances to MSDE 2000 via the
> UPGRADE=1
> UPGRADEUSER=some_login
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/distsql/distsql_71b9.asp
> and not other editions/versions of SQL Server..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
> DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> --------- remove DMO to reply
>
>