I have a stored Proc that runs a DBCC command CHECKIDENT The sproc is being run by a user with adequate permissions. however, it is failing on the DBCC command with the error.
User 'DifferentUser' does not have permission to run DBCC CHECKIDENT for object
I cannot figure out how this user is the one being used I have even removed this DifferentUser from the instance and all of the databases.
I am in a quandary