Finding the Compatibility Level

Question

Finding the Compatibility Level

VM-723206

SSCrazy

Points: 2964
More actions
November 9, 2009 at 10:27 pm

#206438

Comments posted to this topic are about the item Finding the Compatibility Level

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

BudaCli Hall of Fame Points: 3384 More actions · Answer 1

I just took my chances but I was pretty sure that I have never seen the SP_Compatibility sysprocedure and the sp_help was not even an option for me.Nice Q though

What you don't know won't hurt you but what you know will make you plan to know better

Noel McKinney Hall of Fame Points: 3451 More actions · Answer 2

Good question, the "sp_compatibilitylevel" choice almost tricked me into getting confused with sp_dbcmptlevel (which gives the compatibility level if you just pass the database name parameter alone).

Michael Poppers SSCrazy Points: 2149 More actions · Answer 3

I had no idea that 'sp_helpdb' returned more than the "name"s of the databases (my iSQLw results are "to text," the "name"-column output takes up the entire window, and I never scrolled to the right)! Keep those Qs coming -- even when I get 'em right, I learn something new nearly every day.

jminette Ten Centuries Points: 1322 More actions · Answer 4

I didn't see a "Right click -> Properties -> Options" as one of the choices...:-P

SanjayAttray SSChampion Points: 13157 More actions · Answer 5

A very Important command that anyone working on sql server should know (be it a developer or dba). It gives very basic onset information about database on server like

DB name,DB_Size,DB Owner,dbid,DB Createdate,Status, Updateability, UserAccess, Recovery, Version, Collation, SQLSortOrder, IsTornPageDetectionEnabled, IsAutoCreateStatistics, IsAutoUpdateStatistics, IsFullTextEnabled

and compatibility_level

SQL DBA.

Slick84 SSCertifiable Points: 5602 More actions · Answer 6

I've always used the system stored procedure sp_dbcmptlevel for finding out or altering the compatibility levels of our databases. I've used sp_helpdb but wasn't sure it provided the compatibility level as well. Fun q.

--
:hehe: