See http://msdn.microsoft.com/en-us/library/aa933547%28SQL.80%29.aspx

Yes, I noticed - sorry to trouble you, and thank's for a great article.

Have tried to run it (copy + paste) but get errors.

What could I be doing wrong?

It's very neat and all, and maybe I misunderstand, but if the tables are identical, couldn't you avoid the whole duplicates issue by inserting into one table only, and let...

We have to change both our normal user pw, and for those of us that have admin privileges, also our admin password(s), once a month.

Afaik we don't have users sticking...

Great article, but something went wrong when I ran the sample code - it returns an empty message.

??

BR

Peter Pirker

Not help exactly - more like education in etiquette 🙂

Rule # 1: Thou shalt not cross-post!

What with Try...Catch you could just insert and - if you get an error (never mind which one) - issue an update.