rollback via query analyser

[foldface]

Hi
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.

Ta
F

[David Portas]

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
--