Error message - view server state permission was denied - when connecting to SQL Server 2014 using SQL Server 2012 Management Studio When right-clicking on a table and selecting "select top 1000 rows", I get this error:



Is there any workaround, other than the obvious upgrade to SQL Server 2014?
The least intrusive way to get this working is to either use the following command or have the DBA issue this command for you:

use master
go
GRANT VIEW SERVER STATE TO &lt;user_name&gt;