Finding the Compatibility Level

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

  • 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
  • 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).

  • 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.

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

  • 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.

  • 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.


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

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