Link to home
Start Free TrialLog in
Avatar of Amanda Walshaw
Amanda WalshawFlag for Australia

asked on

sql 2008 execute permission object xp_regnumvalues

In our application trying to save revaluation, and we are coming up with the following error
Database error 229: The execute permissions was denied on the object 'xp_regnumvalues', database 'mssqlsystemresource', schema 'sys'.
Avatar of Matt Bowler
Matt Bowler
Flag of New Zealand image

Should this be xp_regenumvalues?
Does the account that is attempting to run this procedure have sysadmin rights on the server?
Avatar of Amanda Walshaw

ASKER

no in our production environment they do not have that I am testing DR.

yes correct it should  this is  xp_regenumvalues?
ASKER CERTIFIED SOLUTION
Avatar of Matt Bowler
Matt Bowler
Flag of New Zealand image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
HELLO ITS ALRIGHT I WORKED IT OUT
BUT YOUR COMMENT PUT ME ON THE RIGHT TRACK

it was
grant execute on  object: master..xp_regenumvalues to public

as they all need to use it.

thanks
great news
it varyed from the real solution and it worked.