Using SSMS 2016 sa user can't see stored procedures in a database. (can see all sys stored procedures) I am logged in as db owner; I can see them, but I can't execute them. I get this message: > Msg 2812, Level 16, State 62, Line 1 > Could not find stored procedure > 'GetConvRows'. If I right-click on the procedure in the object explorer, I can execute it.
***SEE COMMENTS BELOW*** You may need to give yourself permissions to execute stored procedures. You will have to create the role first though. CREATE ROLE sp_execute GRANT EXECUTE TO sp_execute Then grant yourself the sp_execute role for that particular database.