GCottle: Renumbering approach did cross my mind however I envisaged it to be done without cursors. Our data can be few thousands items (which, I have to admit, I failed...

dkretz: I'm not sure how your code is different from mine (apart from couple error checks and one bug ). I guess it would be helpful if...

Looks like you have a requirement to "skip" offending records without failing the insert, otherwise why not just to create unique constraint on all three columns?

But lets assume that...

Andy,

very good article on trigger bypass, indeed. One thing that I wanted to mention - comes from a bitter personal experience with CONTEXT_INFO. As you're aware, it is an...

I assume that you want to change passwords in T-SQL where you can use sp_password procedure:

sp_password 'old_password','new_password', 'login'

for example to change password for sa:

exec sp_password 'foo', 'zoo', 'sa'

There...

quote:

---

Actually, they'll be ordered by the clustered index (but don't tell anyone I wrote that, as it's not admitted by Microsoft).