|
|
|
Mr or Mrs. 500
 
Group: General Forum Members
Last Login: Wednesday, January 27, 2010 9:43 AM
Points: 565,
Visits: 177
|
|
|
|
|
|
SSChasing Mays
Group: General Forum Members
Last Login: Friday, March 19, 2010 1:15 AM
Points: 668,
Visits: 294
|
|
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
|
|
|
|
|
SSCommitted
Group: General Forum Members
Last Login: Wednesday, March 17, 2010 6:15 PM
Points: 1,876,
Visits: 696
|
|
| 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).
|
|
|
|
|
SSC Veteran
Group: General Forum Members
Last Login: Monday, February 22, 2010 10:18 AM
Points: 236,
Visits: 131
|
|
| 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.
|
|
|
|
|
SSChasing Mays
Group: General Forum Members
Last Login: Tuesday, March 09, 2010 3:26 PM
Points: 606,
Visits: 416
|
|
I didn't see a "Right click -> Properties -> Options" as one of the choices...
|
|
|
|
|
Hall of Fame
Group: General Forum Members
Last Login: Friday, March 19, 2010 11:12 AM
Points: 3,212,
Visits: 972
|
|
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.
|
|
|
|
|
SSC Veteran
Group: General Forum Members
Last Login: Today @ 7:33 AM
Points: 284,
Visits: 987
|
|
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.
--
|
|
|
|
