Thanks for the advice guys,

I'm kinda new to this. Would someone be kind enough to provide me examples of what the trigger code would look like.

And/Or the Proc.

Many thanks.

Thanks. So is there a way round it?

Any gurus out there got a simple solution for me?

Thanks everyone for your recommendations,  I'll check them out at Amazon.

Thanks for that sushila, but I've already borrowed "Professional Sql Server 2000 Programming" and the author, Robert Vieira deliberately states that he does not go into DBA territory.

Unfortunately the book is...