471,092 Members | 1,540 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,092 software developers and data experts.

rollback via query analyser

I'm expecting the answer no here but its worth asking.
If I wanted to test an arbitary program could I somehow
say in query analyser, start a global transaction on this
database, run my tests, then at the end roll it back from with
query analyser?

I know I can use backup and restore but this would be
easier, still, again, I don't think you can do this.


Jul 23 '05 #1
1 2407
If you are testing code in Query Analyzer itself then yes, you can
begin a transaction and roll back when you have finished. Transactions
are scoped to the session though, so if you are running your code
somewhere else you'll have to begin and rollback transactions within
that code. There are no "global" transactions.

David Portas
SQL Server MVP

Jul 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Alice | last post: by
1 post views Thread by jacob.miles | last post: by
1 post views Thread by cheesey_toastie | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.