Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL2000 upgrade
Message
From
06/03/2006 09:19:32
Keith Payne
Technical Marketing Solutions
Florida, United States
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01101691
Message ID:
01101702
Views:
10
>I had SQL2000 Dev Edition on my XP Pro. I installed SQL2005 on top of it. It installed without any problem. But @@version in 2005 Management Studio returns:
>
>-------------------------------------------------------------------------
>Microsoft SQL Server  2000 - 8.00.760 (Intel X86)
>	Dec 17 2002 14:22:05
>	Copyright (c) 1988-2003 Microsoft Corporation
>	Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
>
>
>(1 row(s) affected)
>
>
>What do I need to do to activate SQL2005?

SQL2005 does not automatically assume control of your existing databases. You have to manually move your databases from the SQL2000 instance to the SQL2005 instance. Then connect to the 2005 database in SSMS.

To move the data, detach the database and re-attach on the 2005 instance (back up the database first).
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform