Good article. I too am amazed by how many people are willing to forgo primary keys on small tables. Data integrity always preceeds performance (esp such a slight...

I agree this is a great tool. We ran a lot of tests and simulated several disasters, all of which we recovered from. The interface is not entirely...

Two issues on the above statement:

I would write the commit trans statement as

IF @@transcount>0 COMMIT TRANS

Also, you are returning a value of 0, which indicates no error. Use RETURN(-1)...