• There are some utilities, like checkident and set identity_insert, that are not designed to allow anyone to use them. The reason is likely that often the developer's have not thought threw the impact of having people run them

    Why do you need public to run this. I'd argue this is a bad idea. It should be controlled and run by someone with admin type privldges.

    On a side note, granting rights to public is a bad idea.

    Steve Jones

    sjones@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/sjones

    http://www.dkranch.net