Thanks to All who replied. WeI just upgraded from 7.0.01 Unpatched to Patch 002, and believe it or not, the sql error just stopped. I suspect that it was using 2000 libraries and Patch 002 resolved.
Thanks Joe and Bill for your help! Jase Brandon On 3/11/08, Joe D'Souza <[EMAIL PROTECTED]> wrote: > > ** Yes it is, this object has been removed in MS-SQL 2005. > > https://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=229015&SiteID=1 > > It is looking for this perhaps because the AR System server was installed > on MS-SQL 2000, and the database was later upgraded. Two things you can do > to resolve this.. Install the MS-SQL 2005 client. If this doesn't resolve > your problem, run the upgrade the AR Server and this would install any 2005 > specific libraries if that is missing.. > > Joe > > -----Original Message----- > *From:* Action Request System discussion list(ARSList) [mailto: > [EMAIL PROTECTED] Behalf Of *Jase Brandon > *Sent:* Tuesday, March 11, 2008 1:55 PM > *To:* arslist@ARSLIST.ORG > *Subject:* Re: SQL Server 2005 Dbase Error > > ** Hi Joe, > My Apologies for not being precise. > > The exact error is shown below. In my humble opinion, it appears that the > server is trying to referenece a dbase object that doesn't exist. > Any input is greatly appreciated > Thanks, :) > > <SQL > <TID: 0000003580> <RPC ID: 0000897137> <Queue: Admin > > <Client-RPC: 390600 > <USER: [EMAIL PROTECTED] > > /* Fri Jan 25 2008 12:21:18.1240 */*** ERROR *** Invalid object name > 'master..spt_server_info'. (SQL Server 208) > > > > On 3/11/08, Joe D'Souza <[EMAIL PROTECTED]> wrote: > > > > ** Jase, > > > > What was the exact error? > > > > Joe > > > > -----Original Message----- > > *From:* Action Request System discussion list(ARSList) [mailto: > > [EMAIL PROTECTED] Behalf Of *Jase Brandon > > *Sent:* Tuesday, March 11, 2008 11:48 AM > > *To:* arslist@ARSLIST.ORG > > *Subject:* SQL Server 2005 Dbase Error > > > > ** Hello All, > > ITSM 7.0.01 > > SQL Server 2005 > > > > We are getting the strangest error in the sql logs, trying to reference > > the table "spt_server_info". > > I have spoken with our DBA and he said this table only existed in SQL > > Server 2000 and not in 2005. > > Has anyone seen anything like this? I don't know how to proceed. Any and > > all comments/questions are appreciated. > > > > Thanks, > > > > Jase Brandon > > > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > > html___ > > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ > > __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"
