thanks for that. It all seems reasonably straight forward. The database im currently looking at is in simple recovery mode, which according to the article is bad. ...

Cheers guys that makes total sense. Im going to be taking a full backup of our defined databases once a day. Should i backup up the transaction log as...

thanks for that. ill have a look. On another note. How does sql server handle syntax errors with transactions. Would the transaction still be rolled back...

yes it will continue but it want execute the code in the second if statement. Is this not a good way of doing it?

oops forgot to mention we are using sqlserver 2000