SQL Server Error Msg 10531 – Cannot create plan guide ‘%.*ls’ from cache because the user does not have adequate permissions. Grant the VIEW SERVER STATE permission to the user creating the plan guide.

In this blog post, let’s learn about the error message “10531 – Cannot create plan guide ‘%.*ls’ from cache because the user does not have adequate permissions. Grant the VIEW SERVER STATE permission to the user creating the plan guide.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.

SQL Server Error Message

10531 – Cannot create plan guide ‘%.*ls’ from cache because the user does not have adequate permissions. Grant the VIEW SERVER STATE permission to the user creating the plan guide.

Reason for the Error

To be update soon…

Solution

To be update soon…