sp_updatestats - User does not have permission to perform this action

Question

According to

http://msdn.microsoft.com/en-us/library/ms173804(v=sql.110).aspx

Permissions
--------------------------------------------------------------------------------
 
Requires membership in the sysadmin fixed server role, or ownership of the database (dbo).

the security context within which sp_updatestats is being executed can be sysadmin server role OR "ownership of the database (dbo)".  By "ownership of the database (dbo)" would that include anyone who has the db_owner database role membership?

---

May we all make money in the sequel.

Answer 1

No, you can execute sp_updates only if you are the actual owner of the database

Its a bug

http://microsoft.public.sqlserver.programming.narkive.com/VMUuTq0i/bug-in-sp-updatestats

you can try a workaround in the below link

http://connect.microsoft.com/SQL/feedback/ViewFeedback.aspx?FeedbackID=436562

--Prashanth

Answer 2

Thanks.  It appears to exist in version 11.0.3000.0 as well.

---

May we all make money in the sequel.