Help! SQL Server 2008 Shows 2000!!!

[hneal98]

Sorry, but I am a bit stupid with the new SQL Server versions.

I set up a SQL 2008 on my PC, but had problems loading a sample database. I ran SELECT @@Versions and it returned Version SQL Server 2000.

Can someone explain why this would be and how do I upgrade it to 2008?

Thanks and sorry for being so dense. :-(

http://www.totalsecurityforyou.com

for any personal security products.

 

[markros]

Check SELECT
SERVERPROPERTY('Edition') AS Edition,
SERVERPROPERTY('ProductVersion') AS ProductVersion,
SERVERPROPERTY('ProductLevel') AS ProductLevel

and also verify compatibility level for your database.

 

[mrdenny]

Are you connecting to the SQL Instance on your local machine, or a remote instance? The version which is returned by SELECT @@VERSION is the version which is running on the SQL Server Instance you are connected to, not the version of your client.

If the server is running SQL 2000, you'd need to upgrade the server to SQL 2008 (which requires a lot of testing before doing) before SELECT @@VERSION will return SQL 2008.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog

 

[hneal98]

marcos,

I ran the query you posted. Here is the results:

Edition ProductVersion ProductLevel
Desktop Engine 8.00.194 RTM

however; I am not sure how to interpret it.

mrdenny,

I am not connected to a server at all. Just my local machine. It may very well be that the SQL Server 2000 service is still running as apposed to the SQL 2008 service.

I will check that.

Thanks,

Harvard

http://www.totalsecurityforyou.com

for any personal security products.

 

[gmmastros]

I ran the query you posted. Here is the results:

Edition ProductVersion ProductLevel
Desktop Engine 8.00.194 RTM

however; I am not sure how to interpret it.

Edition = Desktop
Since your edition is reporting as "Desktop", this means you are using the free version of sql server (known as MSDE2000). There are limitations to the free version that usually does NOT affect smaller databases.

Product Version = 8.00.194
All versions of SQL Server 2000 report 8 as the major version number.

Product Level = RTM
RTM means "Release To Manufacturing". This was the first version of SQL Server 2000 that microsoft shipped. There were 4 service packs released later. If you had one of the service packs installed, your version number would have been different and the product level would say "SP4" (for example).

If you intend to stick with MSDE, I would encourage you to at least apply the service packs. Service packs are cumulative, which means you can install service pack 4 without having to install 1, 2, or 3.

If you want to upgrade to SQL 2008, then do a google search on [google]SQL Server 2008 Express Download[/google]. I recommend the express version because you are already using the free version of SQL 2000, so the size limitations are clearly not a problem for you.

MSDE2000 (the version you currently have installed) is limited to 2 gigs per database. SQL Express (the free version of SQL2005 and SQL2008) is limited to 4 gigs per database.

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[hneal98]

I am supposed to be using the evaluation version of 2008. I had 2000 on the machine before, but removed it for this installation, but some how it still seems to think it is 2000.

http://www.totalsecurityforyou.com

for any personal security products.

 

[markros]

I believe there was a question of how to completely uninstall SQL Server prior to installing SQL Server 2008 Express in ASP.NET forums - would be a bit hard to find.

I would suggest you to ask this question also in

http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/threads

or

http://social.msdn.microsoft.com/Forums/en-US/sqlexpress/threads

 

[hneal98]

Thank you everyone for your responses. I ended up uninstalling SQL Server 2008 and reinstalling it and everything is fine now.

Not sure why it was showing 2000, but it works now.

Thanks again.

Harvard

http://www.totalsecurityforyou.com

for any personal security products.