How in SQL Server Management Studio 2008 to rollback easily?
I'm used to setting Oracle's tools to not auto-commit, run statements, then click a 'rollback' button if I'm not happy with the result. I'm hoping I'm overlooking something in开发者_开发知识库 Microsoft's tool...
As far as I remember, you can do it by SET IMPLICIT_TRANSACTIONS ON
(also with SET ANSI_DEFAULTS ON
for connection.
精彩评论