Ya anytime you build something like this make sure you manually run it once, then after all the bugs are gone you can set up an sp with dynamic sql to...

No need to have a reason Brian.  I'm just not used to that fact that's all there is to it ...  especially when someone...

Can you post the final script you used?  That'll help someone else who stumbles on that thread in the future.

Lol, feels strange to see that everyone knows my name... even if I changed my nick a few years back .

Just curious, why did you need to have an order on the ident column???

Not if the indentity order needs to be different than the clustered index.  In that case you always have to do some extra work.

If you don't have auditing in place you need a log reader.  That assuming that you have log backups going that far in the past.

In 2005, you can use the...

Nice article.

So what's the next tame those strings article in this serie?

I haven't checked that in a long while... maybe it's possible, but my current conclusion is do NOT rely on that table.  Even Microsoft warns us that you can't rely...

And here's our winner .

Ya nice catch.

RUN DBCC CHECKCONSTRAINTS to see if there are any other tables in this situation.

That can happen if a constraint was added without full validation, or if it was...

Ya that's a not so obvious anti-spam trick... maybe it was a little overkill in this situation however .

Is there any way you can create a new database and export those 2-3 tables there.  Then backup the data and send it to me so I can check it...

Thanx .

"Sooner or later, maybe those countries will outsource their work back to US !!"

I think that it'll be outsourced to Canada first so it looks like I'll be working for...