Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

compatibility level Expand / Collapse
Author
Message
Posted Monday, November 09, 2009 10:27 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Tuesday, July 23, 2013 6:34 AM
Points: 654, Visits: 265
Comments posted to this topic are about the item compatibility level
Post #816312
Posted Tuesday, November 10, 2009 12:19 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, November 05, 2013 6:08 AM
Points: 1,076, Visits: 591
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
Post #816322
Posted Tuesday, November 10, 2009 5:44 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, February 11, 2014 4:12 PM
Points: 2,007, Visits: 768
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).
Post #816420
Posted Tuesday, November 10, 2009 8:24 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Tuesday, March 04, 2014 7:41 PM
Points: 634, Visits: 399
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.
Post #816581
Posted Tuesday, November 10, 2009 9:01 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Wednesday, February 20, 2013 11:24 AM
Points: 627, Visits: 451
I didn't see a "Right click -> Properties -> Options" as one of the choices...
Post #816611
Posted Tuesday, November 10, 2009 9:14 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, April 17, 2014 11:58 AM
Points: 3,924, Visits: 1,588
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.
Post #816625
Posted Tuesday, December 01, 2009 1:39 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Monday, October 31, 2011 1:10 PM
Points: 480, Visits: 1,163
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.

--
Post #827006
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse