I can't help you directly but looking forwards you might consider implementing Insert/Update triggers or augmenting existing ones to track who created and changed what. How detailed you make the tracking...

OK. Thanks for all your input. Much appreciated. I'll consider this post closed.

Regards

Derek

Regarding point 3. Would creating a view with a clustered index on left(<colname>,5) achieve this?

...I wondered who hired those staff after I sacked them.

...and hats off to those that answered it "top 100 rows".

If you're going to get it wrong anyway, might as well go for it!

Very poor question but if that's how it's going I have one for you...

Question: You are in Tronto, how far is it to Washington, DC?

Answer : You're wrong. Well, I...

Hi,

Europe most uses EAN format code which are similar enough to UPC. Here's one I wrote earlier...

It checks to see if the checksum digit is valid.

/*check for UPC-A style barcode....

Nice article. I'd like to see more practical ones such as this.

One small point - timestamp. If you're moving tables between servers then you may get duplicate timestamp data when...