sql server compatibility mode

General Web Coding Microsoft Development
1

Okay, this is not related to jodo in anyway. I just curious if any of your fellow .net developer has dealt with sql server compatibility mode.

Here at work, we needed to change our sql server 2005 's compatibility mode to 9. I use managment studio express and from what I understand, I should right click on database, choose properties, then options. but I can’t seem to do that, always come up with some errors.

Is there any other ways to change the compatibility mode?

any advice is appreicated.

2

(Ok, I fought javascript & cookie issues of this website for long enough to be able to actually post this, so here goes.)

See the T-SQL command sp_dbcmptlevel

and web reference may be found here
sys.sp_dbcmptlevel (Transact-SQL) - SQL Server | Microsoft Learn