Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Steve Jones Fixing Your Identity RE: Fixing Your Identity
yihua833
SSC Enthusiast
Points: 110
More actions
March 19, 2003 at 5:56 pm
#451506
the problem is we need db_owner or sysadmin to execute 'DBCC CHECKIDENT '.
what about if user is a public role?
my problem is i have a store porcedure with 'DBCC CHECKIDENT '.
But a public role user cann't run it.