Does not have permission to run DBCC CHECKIDENT

Muhammad Ari

Does not have permission to run DBCC CHECKIDENT

by Muhammad Ari » Wed, 16 Sep 2009 18:59:57

I have created a stored procedure in which i have created a temproray table with 2 fields, one is IDENTITY column and i set the seed by using DBCC CHECKIDENT but it gave an error about permission.

Please give suggestion for resolving this issue.




Mani

Does not have permission to run DBCC CHECKIDENT

by Mani » Fri, 18 Sep 2009 20:00:58

DBCC CHECKIDENT permissions default to the table owner, members of the sysadmin fixed server role, and the db_owner and db_ddladmin fixed database role

Pls check the ONLINE Document for more details..