Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL2000 upgrade
Message
De
06/03/2006 09:19:32
Keith Payne
Technical Marketing Solutions
Floride, États-Unis
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Titre:
Versions des environnements
SQL Server:
SQL Server 2005
Divers
Thread ID:
01101691
Message ID:
01101702
Vues:
11
>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).
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform