Rollback occurs during XDocument.Query()

[SChapman]

Hello,

I am trying to use a stored procedure to insert a record into a database
when a user clicks on a button. I followed this microsoft article
http://support.microsoft.com/?kbid=827007 that suggests I can submit to a
stored procedure using XDocument.Query(). After my table was never updated,
I ran a trace and discovered that after running my command, a rollback
command is also issued from IP (which must be part of the Query() sub since I
am not sending that command). How can I get this rollback command to stop
being sent??

Thanks for any help or advice!
SChapman