November 24, 2008 at 4:51 am
If a sql file does not has a corresponding commit/rollback transaction against a Begin Tran ... and is executed through sqlcmd than what will be the transaction state....??
Regards,
[font="Verdana"]Sqlfrenzy[/font]
November 24, 2008 at 5:42 am
The transaction will remain open as long as the connection is open. If you close the connection without issuing a commit, the transaction will be rolled back.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy