That was just a first ditch thing really to check. Are there any layers you are going through such as com+, nested transactions etc? Do any of the tables you are updating have triggers?
-----Original Message----- From: Andy and Kim Mills [mailto:[EMAIL PROTECTED] Sent: 24 January 2005 6:14 To: [email protected] Subject: Re: RE: [ASP] .ASPX and Stored Procedure Adrian: Thanks for the suggestion. I turned on the SQL Profiler and it seemed like nothing was wrong, as I got a SQL:BatchCompleted and didn't notice any errors. Is there something specific you think I should be looking for in that Profiler? Thanks again Andy ----- Original Message ----- Something is probably trying to be clever behind the scenes by wrapping your work in a transaction. Have you tried using the SQL Profiler to see what is happening exactly on the server? It should through up any implicit transaction issues. [Non-text portions of this message have been removed] --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [email protected] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links The contents of this email and any attachments are sent for the personal attention of the addressee(s) only and may be confidential. If you are not the intended addressee, any use, disclosure or copying of this email and any attachments is unauthorised - please notify the sender by return and delete the message. Any representations or commitments expressed in this email are subject to contract. ntl Group Limited --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [email protected] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/active-server-pages/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
