Eric,
Here is your answer: You are seeing this because Microsoft disabled Distributed Transactions by default in Windows Server 2003 due to security problems. Get Microsoft Knowledgebase Article 816701 (Error Message: OLE DB provider SQLOLEDB was unable to begin a distributed transaction). It gives you instructions on what to change to enable them in Server 2003. Basically, you need to access the Add-Remove Programs, Add/Remove Windows Components, Application Server, Details, and select the "Enable network DTC access" checkbox. Restart DTC and try it again. All Remedy transactions are Distributed Transactions. HTH, Roger A. Nall Manager, OSSNMS Remedy T-Mobile USA Desk: 813-348-2556(New) Cell: 973-652-6723 FAX: 813-348-2565 sf49fanv AIM IM RogerNall Yahoo IM ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Dunn, Eric Sent: Friday, June 01, 2007 2:12 PM To: arslist@ARSLIST.ORG 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) 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"
