SQL compatibility Level Recommendation for your Database

For best results we recommend you set the compatibility level of your database to match the version of SQL server you are running the database on. So if you have a SQL 2000 or 2005 db you have restored onto a new SQL 2008 server you should set it to 100.

90 = SQL Server 2005100 = SQL Server 2008

Like this:

Be the first to like this post.

This entry was posted on July 28, 2010 at 9:05 pm and is filed under SupportSite, UniversitySite. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply Cancel reply

Enter your comment here...

Please log in using one of these methods to post your comment:

Email (required) (Address never made public)

Name (required)

Website

You are commenting using your WordPress.com account. ( Log Out / Change )

You are commenting using your Twitter account. ( Log Out / Change )

You are commenting using your Facebook account. ( Log Out / Change )

Cancel

Connecting to %s

Support