compatibility level

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by VM » compatibility level

compatibility level

Rate Topic

Display Mode

Topic Options

Author

Message

VM-723206

Posted Monday, November 09, 2009 10:27 PM

SSChasing Mays

Group: General Forum Members
Last Login: Saturday, April 06, 2013 12:20 AM
Points: 649, Visits: 263

Comments posted to this topic are about the item compatibility level

Post #816312

BudaCli

Posted Tuesday, November 10, 2009 12:19 AM

Ten Centuries

Group: General Forum Members
Last Login: Wednesday, March 27, 2013 9:02 AM
Points: 1,046, Visits: 573

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

Noel McKinney

Posted Tuesday, November 10, 2009 5:44 AM

SSCrazy

Group: General Forum Members
Last Login: Thursday, April 05, 2012 2:35 PM
Points: 2,007, Visits: 767

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

Michael Poppers

Posted Tuesday, November 10, 2009 8:24 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, January 17, 2013 2:34 PM
Points: 565, Visits: 360

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

jminette

Posted Tuesday, November 10, 2009 9:01 AM

SSChasing 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... Tongue

Post #816611

SanjayAttray

Posted Tuesday, November 10, 2009 9:14 AM

Hall of Fame

Group: General Forum Members
Last Login: Friday, March 15, 2013 2:43 PM
Points: 3,924, Visits: 1,554

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

Slick84

Posted Tuesday, December 01, 2009 1:39 PM

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

--
Hehe

Post #827006

« Prev Topic | Next Topic »

Permissions