... <crickets chirping> ... I don't think that was a rhetorical question, in case anyone official is wondering...
Rick -----Original Message----- From: strauss <[email protected]> Date: Wed, 7 Apr 2010 14:06:20 To: <[email protected]> Subject: Re: Re : analytics7.6/ DB MS SQL 2005 On SQL Server 2008, Analytics 7.6 created one table within arschema, and four external to it in the ARSystem database: ANA:Fiscal_Calendar (and 7 associated Active Links) ANA_REPORT_TRANSLATION ANA_REPORT_LOCALE DENORMALIZE_BSM_RELATIONSHIPS ANA_TIMEZONE_INFO BTW, Analytics 7.6 is able to connect to an ARS 7.5 patch 4 database hosted on SQL Server 2008 - it makes an OLE DB connection using a MS SQL Server 2005 driver. In contrast, BMC Dashboards 7.6 is completely incapable of connecting to the ARSystem db if it happens to be hosted on SQL Server 2008. I wasted two days before finding that out. So even though it supports ITSM 7.6, and by inference ARS 7.5.00.003 or higher, it does NOT support the database version(s) that ARS does (and has for over a year now). SQL Server 2008 was released in August 2008, and ARS 7.5 in January 2009. What has the Dashboards team been doing for the last 15 months??!! Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing & IT Center http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Frex Popo Sent: Friday, March 05, 2010 7:47 AM To: [email protected] Subject: Re : analytics7.6/ DB MS SQL 2005 ** Better still... select name, type from sysobjects order by 2, 1 Thanks ________________________________ De : Frex Popo <[email protected]> À : [email protected] Envoyé le : Ven 5 Mars 2010, 14 h 44 min 54 s Objet : analytics7.6/ DB MS SQL 2005 Anyone with a working instalation of Analytics 7.6 can tell me what objects get created by the installed? Can anyone run this select on their databse and send us a listing? -- select name, type from sysobjects order by name Very much appreciated frex _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
