Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
New Member
Posts: 1
Registered: ‎04-09-2009

SLX and SQL Server 2005 Compatibility Levels

We have a production installation of SLX 7.2 and a test installation of SLX 7.5.1.  The databases for both versions are running on the same SQL Server 2005 instance.  I have noticed that the SQL Server compatibility level (as shown by sp_dbcmptlevel) for both databases is 80, which appears to be identified as SQL Server 2000 compatibility.  I want to run a query directly against the databases that requires compatibility level 90, which is identified as SQL Server 2005 compatibility.  Will I get into trouble with SLX operation, if I change the compatibility levels of either or both of our databases?
Silver Super Contributor
Posts: 801
Registered: ‎03-24-2009

Re: SLX and SQL Server 2005 Compatibility Levels

No, you'll be fine - we set ours to 100 (SQL2008) with no issues.