Dave, What ARS version are you on? Is that compatible with SQL 2K5? If not you might have to run a Stored Procedure on MS-SQL to alter the db compatibility level of SQL to the compatible level that is appropriate. I think the stored procedure to change the compatibility level is SP_DBCMPTLEVEL Compatibility levels for different versions of MS-SQL are as follows: 60 for MSSQL 6 65 for MSSQL 6.5 70 for MSSQL 7 80 for MSSQL 2000 90 for MSSQL 2005 For eg if the AR Server is compatible with MS-SQL 2000 and you are on MS-SQL 2005, in your query Analyzer you would run SP_DBCMPTLEVEL ARSystem, 80; You may have to run the statement RECONFIGURE; If you require to run RECONFIGURE, it will prompt you for that.. Hope this helps.. Joe
----- Original Message ---- From: "Drake,Dave" <[EMAIL PROTECTED]> To: [email protected] Sent: Thursday, July 17, 2008 1:06:57 PM Subject: SQL 2K5 ** Hey all, Going to be looking to upgrade a SQL 2K ARS install to SQL 2K5. Does anyone know of, or have, any documentation on the process, pitfalls, etc? Thanks! ARS 7.0.1 p007, SQL 2K, Win2K3 servers, ITSM (AM/CM) 7.0.1 p003, CMDB 2.0.1 p002 Dave Drake - Remedy Administrator - Cerner Corporation ________________________________ CONFIDENTIALITY NOTICE This message and any included attachments are from Cerner Corporation and are intended only for the addressee. The information contained in this message is confidential and may constitute inside or non-public information under international, federal, or state securities laws. Unauthorized forwarding, printing, copying, distribution, or use of such information is strictly prohibited and may be unlawful. If you are not the addressee, please promptly delete this message and notify the sender of the delivery error by e-mail or you may call Cerner's corporate offices in Kansas City, Missouri, U.S.A at (+1) (816)221-1024. __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
