After Install of 2005 still 2000 Engine!

I have installed the new SQL Server 2005, but I see my local database as version 8.9.193, means SQL Server 2000.

I do not know why setup did not upgrade it. What do I need to do now? I think some new options are now working because of that...

Was your SQL Server 2005 installation successful? And did you do an upgrade, or a separate instance installation? Check to see if you have a second instance of sql server running, this may be your SQL 2005 installation.|||

How to check if I have second instance? How to see all my instances? Thanks

|||look at your services in control panel.|||What should I look exactly at? I see SQl Server (SQl Express) service...|||

That is probably your named instance, which you installed instead of upgraded.

http://msdn2.microsoft.com/en-us/library/ms165614.aspx

You can search msdn for more information regarding your named instance.

|||Is not that SQl Server Express 2005? I had it installed before...|||i just reread your post. where do you see "8.9.193"? if you do "select @.@.version", that will tell you the version of your sql server installation.|||Thanks. I have executed the SQL:

Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48 Copyright (c) 1988-2000 Microsoft Corporation Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

Seems I have still the old version of SQL, however I can not run Enetrprise Manager anymore, it gives me some strange errors. However it seems I can manage this instance as well as SQl Server Express instance from the new SQL Management Studio. The problem is that some options do not work (grayed out). I think the reason is that this version was not upgraded.

Can I upgrade this version without using Setup? My DVD has some scratches...|||

Hi I wonder now. Is it possible that SQL Express 2005 has been upgraded to full version, but the instance is still called SQLExpress, even it is full version SQL Server 2005?

Please let me know. Thanks

|||

I have tried to copy database from SQL 2000 instance but it does not accept this destination name: h001335\SQLEXPRESS

I have checked the speeling, it is correct instance.

Any idea?

|||

After ignoring the previous message I got the following:

TITLE: Copy Database Wizard

The server is SQL Server Express. This application will not work with Express Edition.

BUTTONS:

OK

|||Seems it never upgraded SQL Express.. I wonder... So it seems I have two versions: SQL 2000 and SQl Express. What is the version difference betwen SQL Express and SQl Server 2005? How to tell?|||How to tell the difference between SQL Express 2005 and SQL Server 2005? How to check?|||

Radiogeneris, please read the Books Online that came with your SQL SErver 2005 installation, it will give you a good overview as well as help you better understand your installation process/problems.

You can also access it online at http://msdn2.microsoft.com/ms165606(en-US,SQL.90).aspx.

After you've read the documentation, please feel free to post any follow up questions.