January 29, 2010 at 6:19 am
I just upgraded a sql 2005 sp3 cu7 server to sql 2008. Weird thing is that when i went to convert the databases from 90 to 100 i did not see 100 in the drop down box.
I figured i would run sp_dbcmptlevel <dbname>, 100; and see what error i got and troubleshoot that.
the statement succseeded. so i went back in to check the database properties and it is blank. it lists 90, 80, and 70 in the drop down box, but I do not see 100 listed.
...any help would be greatly appriceated
Twitter: @SQLBalls
Blog: http://www.SQLBalls.com
Channel: https://www.youtube.com/@Tales-from-the-Field
January 29, 2010 at 6:24 am
Are you connecting to the right SQL 2008 Server ?
Check and double check that.
I don't think a database in SQL Server 2008 shows the compatibility as 70.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
January 29, 2010 at 6:28 am
Yep, I look a the server and I see that it is build 10.0.2531, and if i run sp_dbcmptlevel <dbname> I get as a return.
"The current compatibility level is 100."
however in the drop down list, I do not see it.
I'm not sure if this is such a big deal that I would rebuild the server over it. but i'm uncertian as to why the drop down list is missing 100.
Twitter: @SQLBalls
Blog: http://www.SQLBalls.com
Channel: https://www.youtube.com/@Tales-from-the-Field
January 29, 2010 at 7:04 am
Probably your DB is set in compatibility level 10. I just got one stupid question... What version of the SSMS are you using? Is it still SSMS 2005 version or 2008 version?
-Roy
January 29, 2010 at 7:12 am
SSMS 2008, I believe you should get an error if you use SSMS 2005 trying to connect to a SQL 2008.
😀 no worries it always helps to check the basics.
I think it has something to do with the build.
I just connected to another SQL 2008 SP1 server and right clicked on one of it's databases I know to be in 100 mode, and it returns blank as well.
I'm trying to log in from another sever and getting a firewall error, once i open the ports i'll see if i can see the compatibility level from another server.
Twitter: @SQLBalls
Blog: http://www.SQLBalls.com
Channel: https://www.youtube.com/@Tales-from-the-Field
January 29, 2010 at 7:14 am
"Slap myself in on my forehead" Forgot that you cannot connect from SSMS 2005 to SQL 2008 DB
-Roy
January 29, 2010 at 7:18 am
Well I wish I had a more defined answer, but after the reboot for the ports it is now listed. I can see 100 compatibility level........
Ty for all the responses!
🙂
Twitter: @SQLBalls
Blog: http://www.SQLBalls.com
Channel: https://www.youtube.com/@Tales-from-the-Field
January 29, 2010 at 1:04 pm
Roy Ernest (1/29/2010)
"Slap myself in on my forehead" Forgot that you cannot connect from SSMS 2005 to SQL 2008 DB
Well Roy - you might want to slap yourself a bit harder. Yes, in fact - you can connect to a SQL Server 2008 system using SSMS 2005. And (I just tested this), when you do so and check the database properties - the compatibility version for 2008 does not show up in the drop-down.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 29, 2010 at 1:45 pm
Roy Ernest (1/29/2010)
"Slap myself in on my forehead" Forgot that you cannot connect from SSMS 2005 to SQL 2008 DB
It happens Roy, sometimes we forget pretty trivial things....
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
January 29, 2010 at 2:00 pm
Jeffrey Williams-493691 (1/29/2010)
Roy Ernest (1/29/2010)
"Slap myself in on my forehead" Forgot that you cannot connect from SSMS 2005 to SQL 2008 DBWell Roy - you might want to slap yourself a bit harder. Yes, in fact - you can connect to a SQL Server 2008 system using SSMS 2005. And (I just tested this), when you do so and check the database properties - the compatibility version for 2008 does not show up in the drop-down.
I just asked my friend to slap me... 😀
-Roy
January 29, 2010 at 2:23 pm
If I remember rightly, to connect to SQL 2008 using MMS 2005 you need the client tools patched up to SP3, doesn't answer the original question, but my two cents.
andrew
January 29, 2010 at 2:27 pm
Andrew, I tried it after looking at your post, it works so you are right, my 2005 SSMS is up to the latest patch..
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply