I don't have 2005 installed here.

What have you found in the relations of the system tables?

I'm gonna go out on a limb and presume that logging takes more space than the actual data... but 2X, that's seems a lot.

Maybe a lot of indexes need to...

Have you tried deleting the maintenance plan linking to that job?

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 .