Eric, The error is likely due to DTC not completely configured on both the local and remote servers. There are a number of previous posts regarding this issue. Another possibility is that ARS 6.3 is not supported with SQL Server 2005. Stephen
________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Dunn, Eric Sent: Friday, June 01, 2007 2:12 PM To: [email protected] Subject: SQL Stored Procedure Part II ** I forgot to add the error: ARERR [552] Failure during SQL operation to the database : The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION. (SQL Server 3903) ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Dunn, Eric Sent: Friday, June 01, 2007 2:10 PM To: [email protected] Subject: Stored Procedure in Remedy 6.03 ** I have an issue where I can not run a SQL Server Stored Procedure from inside the client - but runs fine from Query Analyzer. The Database is SQL server 2005 with the Remedy server being 6.03 patch 16. Anyone seen this? Eric W. Dunn Programmer Analyst III - Remedy/Collaboration McLeod USA, Inc. - Network Engineering 8665 New Trails Dr. The Woodlands, TX 77381 (281)465-1265 (281)465-1951 fax NOTICE: This electronic mail transmission may contain confidential information and is intended only for the person(s) named. Any use, copying or disclosure by any other person is strictly prohibited. If you have received this transmission in error, please notify the sender via e-mail. __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
