Sage SalesLogix
  • Contact Us
  • Sage North America
800-643-6400
Welcome Twitter Facebook LinkedIn
Community Home Blogs Share Ideas Search Request Access Resources
Reply
New Member
akbrew
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?
Please use plain text.
Bronze Super Contributor
MikeSpragg
Posts: 317
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.
Please use plain text.