@PaulWhite I suppose if the OP clarifies his intent one way or the other, that might help re the dupe.

It might well.

My objections to answers in comments are mainly that they can't be down voted, improved, and may dissuade others from answering. (Plus general comment mess of course.)

Well that's unusual.

@PaulWhite point taken.

@PaulWhite lol

Ha!

@PaulWhite I should have deleted that... would you mind?

Which one? (Mobile!)

^^^ that one

I don't know if you can see that in mobile, lol

but yah, you got it

thanks

Saw it before it went

cool

I am curious to know if he is paranoid or has a particularly awful user assigned db_owner.

@mmarie lol, no doubt.

There are alternatives to db_owner.. I'm guessing awful user.

I'm thinking a really big stick would be a good way of denying that privilege.

public humiliation is my preferred tool

one way would be to create a server-level DDL trigger that prevents DBCC SHRINKFILE operations.

or a pink slip

@swasheck there isn't much that can't be tamed by HR.

@PaulWhite If you want it reinstated I guess it's fine but I wanted to wait until the question is clear maybe. The comments here and yours made me think I misinterpreted it anyway

@TomV - if you undelete your answer, it might help the OP to understand what he wants to do.

undeleted then even if it's not a good answer by any means

only as good as the question :) (frisbee)

@TomV lol. have a +1

I love this answer

@MaxVernon you could not leave it without a Gretzky quote, eh?

@dezso well, you know, he is Canadian, eh!

@MaxVernon yes, heard about that fact

@MaxVernon and if this is the explanation, then you go to bed like this, I imagine:

I just wrote a mile-long answer to the identity question and I'm hovering on the Submit button, fearing that the (rather risky approach) will blow up in the OP's face. The idea is to add a temporary column to hold the existing "identity" values, drop and re-create the identity column (and the primary key on it), then identity_insert the rows back into the table and reseed.

I'd be comfortable doing this myself, but just handing a ticking bomb to some noob on dba.SE? What would you do?

Is there such a thing as a moral responsibility for other people on dba.SE? :)

@dezso nice one!

@DanielHutmacher I'd go for it. Just add "take a backup first, and test restore it somewhere". That should CYA sufficiently.

Done. I'm calling it a friday night. :)

@MaxVernon and that at the very beginning

@DanielHutmacher you own the question

@DanielHutmacher are you sure the PK is clustered?

its a great answer by the way!

@MaxVernon I don't know a thing about the schema. :D

@DanielHutmacher - me either, lol!

I just think it might be worthwhile pointing that out to the OP.

anyway, its Beer:30 here so I'm outta here. See you on mobile.

Have a good one!

No one can pull off saying "I was down under in the bush" like Ellen.

@DanielHutmacher thanks, and same to you!