No problem.. The different compatibility levels for MS-SQL are 60 for MS-SQL 6 65 for MS-SQL 6.5 70 for MS-SQL 7 80 for MS-SQL 2000 90 for MS-SQL 2005 100 for MS-SQL 2008 So if you are on 2005 and the ARS Server is compatible to 2000, you will need to use sp_dbcmptlevel to drop the ARSystem database to 80 from 90.. I remember using this during ARS version 4 days when I accidently upgraded a database for fun from 6.5 to 7 without checking the matrix (as it was a test system), and after digging around a bit on SQL archives I figured there was a way to drop the compatibility level from 7 to 6.5 which is what I did to the ARSystem database.. Having found this out, I experimented with it a bit and found it to be a pretty useful tool to allow older applications connect to a newer version of the DB.. Hope this information helps too.. Joe D'Souza Remedy Developer / Consultant, Shyle Networks, New Jersey.
----- Original Message ---- From: "Nall, Roger" <[EMAIL PROTECTED]> To: [email protected] Sent: Thursday, September 11, 2008 11:21:40 AM Subject: Re: OT:SQL 2008 ** Joe, Thanks for this. We are just getting started on upgrading to SQL 2005 and this question just came up. Hopefully David Easter or Kelly Deaver may have some inside info. Thanks, Roger A. Nall Manager, OSSNMS Remedy T-Mobile, USA Desk:972-464-3712 NEW Cell: 973-652-6723 FAX: sf49fanv AIM IM RogerNall Yahoo IM ________________________________ From:Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Thursday, September 11, 2008 10:02 AM To: [email protected] Subject: Re: OT:SQL 2008 Even if it isn't certified for it, MS-SQL has a way to make itself compatible with applications that are compatible with the earlier versions of the database. There is a stored proceedure sp_dbcmptlevel that you can use to drop the compatibility level of the database to the desired level.. I have used that successfully in the past with ARS after an upgrade of the database caused the AR Server to disconnect with the database.. For information how to use this proceedure visit http://msdn.microsoft.com/en-us/library/ms178653.aspx Cheers Joe D'Souza Remedy Developer / Consultant, Shyle Networks, New Jersey. ----- Original Message ---- From: "Nall, Roger" <[EMAIL PROTECTED]> To: [email protected] Sent: Thursday, September 11, 2008 9:54:45 AM Subject: OT:SQL 2008 ** This may be only slightly off topic and is certainly aimed at BMC for an answer. Does anyone know when Remedy will be certified for SQL 2008? Thanks, Roger A. Nall Manager, OSSNMS Remedy T-Mobile, USA Desk:972-464-3712 NEW Cell: 973-652-6723 FAX: sf49fanv AIM IM RogerNall Yahoo IM _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
