다음을 통해 공유

SQL Server troubleshooting: The EXECUTE permission was denied on the object 'sp_help', database 'mssqlsystemresource', schema 'sys'.

  • 아티클

Symptoms

Msg 229, Level 14, State 5, Procedure sp_help, Line 1 The EXECUTE permission was denied on the object 'sp_help', database 'mssqlsystemresource', schema 'sys'.

 

Solution

Execute the query below:

 

Use Master

Go GRANT EXECUTE ON sp_help to Public