Viewing 3 posts - 1,351 through 1,354 (of 1,354 total)
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...
August 1, 2002 at 6:34 am
#433792
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...
July 22, 2002 at 1:49 pm
#433189
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)...
July 19, 2002 at 2:28 pm
#433125