I am writing stored procedures on MS SQL SRV 2k.
At the beginning I was using Query Analyser to write and debug step by step my sprocs but it wasn't too good ... in fact it was not really good at all :-(

Now I am using .NET and it's muuuch better then QA ,but I miss one functionality from QA - it's "Auto rollback".

So my question is - do you know some good software to write and debug stored procedures on MS SQL SRV 2000???
It could be something that has the functionality of .NET plus "Auto rollback" from Query Analyser.