I have a stored procedure utilizing distributed transactions. When I run
the stored procedure with "BEGIN DISTRIBUTED TRANSACTION" specified, it
hangs where it runs a select statement against the remote server. With the
"BEGIN DISTRIBUTED TRANSACTION" commented, the stored procedure runs ok.
All suggestions are appreciated.
Message posted via http://www.sqlmonster.com
An update to this...
SQL Server 2003 comes with DCTS switched on by default (which I saw in the
properties). However, there is then a security setting that must be set to
allow distributed transactions. I will not know if this did it until the
the setting has been changed and the server rebooted.
Message posted via http://www.sqlmonster.com
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment