It doesn't automatically upgrade - you can run MSDE and SQL
Server 2000 side by side. I would guess that's you ended up
two installations. One is the default instance and one is a
named instance. You can detach your database from MSDE and
attach it on the SQL Server 2000 instance.
-Sue
On Tue, 19 Sep 2006 15:56:00 -0400, Mark
[quoted text, click to view] <murkynow50@yahoo.com> wrote:
>I thought that when you installed SQL Server 2000 the installation
>automatically recognized an instance of MSDE and offered to upgrade you.
>Well, after having installed SQL Server 2000 it looks like my database
>still thinks that it's MSDE. At least I have both SQL Server 2000 and
>MSDE running. Enterprise Manager shows the database as database_MSDE.
>
>How can I tell if the database has really been converted to SQL Server 2000?
>
>mark.
I could've swore the install offered me the option to upgrade. I mispoke
in my inital message. But, anyway, I'll be taking a look at attaching
the database.
Thanks,
Mark.
[quoted text, click to view] Sue Hoegemeier wrote:
> It doesn't automatically upgrade - you can run MSDE and SQL
> Server 2000 side by side. I would guess that's you ended up
> two installations. One is the default instance and one is a
> named instance. You can detach your database from MSDE and
> attach it on the SQL Server 2000 instance.
>
> -Sue
>
> On Tue, 19 Sep 2006 15:56:00 -0400, Mark
> <murkynow50@yahoo.com> wrote:
>
>
>>I thought that when you installed SQL Server 2000 the installation
>>automatically recognized an instance of MSDE and offered to upgrade you.
>>Well, after having installed SQL Server 2000 it looks like my database
>>still thinks that it's MSDE. At least I have both SQL Server 2000 and
>>MSDE running. Enterprise Manager shows the database as database_MSDE.
>>
>>How can I tell if the database has really been converted to SQL Server 2000?
>>
>>mark.
>
Don't see what you're looking for? Try a search.
