December 16, 2009 at 9:39 am
Hi,
I have installed SQL Server 2008 on my machine... but when I create a database I cannot select compatibility level 100 for SQL Server 2008...
The new ALTER DATABSE command is not working... and when I you the old sp to change the level to 100 I get an error.
I can only set the level up to 90.
How can I fix this? (Did I do something wrong when I installed SQL Server 2008?)
Br,
Nicklas
December 16, 2009 at 9:44 am
May be a dumb question here, but are you sure you are using SSMS 2008?
December 16, 2009 at 9:46 am
Sounds to me like you somehow installed SQL 2005. What do you get if you select @@Version?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 16, 2009 at 9:47 am
Yes, I only have SQL Server 2008 installed... and when I start SSMS I get the nice splash SQL Server 2008...
/Nicklas
December 16, 2009 at 9:53 am
When I run SELECT @@VERSION I get
Microsoft SQL Server 2005 - 9.00.4053.00...
How could that be?
If I look on my start menu I have SQL Server 2008 and I have the new yellow line at the bottom of my query window...
However I do not have intellisense...
/Nicklas
December 16, 2009 at 9:56 am
On my about screen I have this info...
SQL Server 2008
Microsoft SQL Server Management Studio10.0.1600.22 ((SQL_PreRelease).080709-1414 )
Microsoft Analysis Services Client Tools2007.0100.1600.022 ((SQL_PreRelease).080709-1414 )
Microsoft Data Access Components (MDAC)6.1.7600.16385 (win7_rtm.090713-1255)
Microsoft MSXML2.6 3.0 5.0 6.0
Microsoft Internet Explorer8.0.7600.16385
Microsoft .NET Framework2.0.50727.4927
Operating System6.1.7600
December 16, 2009 at 9:58 am
Thank's for your quick response...
I guess I have to reinstall SQL Server 2008...
/Nicklas
December 16, 2009 at 9:59 am
Because the DataServer you are connecting to is SQL Server 2005 not SQL Server 2008.
December 16, 2009 at 10:03 am
What that means is you have SSMS 2008, but you're connecting to SQL 2005. The difference is the management software vs the server software.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 16, 2009 at 10:05 am
I connect to my own machine... is it possible to install SQL Server 2005 engine from SQL Server 2008 setup?
I reinstalled my machine last weekend and only installed Visual Studio 2008 and SQL Server 2008...
aaaaaaaaaaaaaa......... SORRY all of you...
Visual Studio 2008 installed a SQL Server EXPRESS and that version is 2005...
Connected to the wrong instance... hmmm...
:blush:
/Nicklas
December 16, 2009 at 10:08 am
I am almost baldheaded because of this stupid mistake...
Sorry for taking your time.
Br,
Nicklas
December 16, 2009 at 10:09 am
Not a problem. Easy mistake to make.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 19, 2009 at 8:52 am
Installed SQL 2008 and moved DB from SQL 2005 which as 80 Mode as not updated to 90. Application itself was clever enough to say can't run on SQL 2008. The DBA just changed to 100 thinking that be the fix before I could explain need SQL 2005 set up. He then set it back to SQL 2000 80. What is the ramifications of just doing this 80 to 90 to 100 then back again to 80. Im sure I read something that you cannot revert back. Any system threads on the problems would be appreciated.
December 19, 2009 at 9:03 am
TRACEY-320982 (12/19/2009)
What is the ramifications of just doing this 80 to 90 to 100 then back again to 80.
Absolutely none. You can change compatibility level as often as you like in any direction.
What cannot be done is to take that SQL 2008 database and restore/attach to SQL 2005. There is no way to take a database from a higher version of SQL and put it back onto a lower level.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 19, 2009 at 3:14 pm
Thanks I thought once you updated statistics for sql 2005 90 mode database the statistics still be in the system files.
Viewing 15 posts - 1 through 15 (of 15 total)
You must be logged in to reply to this topic. Login to reply