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?
Just for reference, this problem seems to be related to this Connect bug:
Cannot view properties of database when using db owner account - by Jimmy Rudley
Posted by Microsoft on 7/9/2013 at 2:47 PM
[...] We have corrected this for the next version of SQL 14.
Walter A Jokiel, Program Manager, SQL Server
I have the same problem with SQL Server 2012 Management Studio 2012.
If anyone finds themselves stuck with this problem, try to update SQL Server Management Studio. This way, you don't need to grant the permission
VIEW SERVER STATE to the user.
Using SQL Server Management Studio 2014 (12.0.4213.0) now, and the problem seems to be gone.
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 <user_name>
You will get this error message if the user was granted
SELECT on single tables.
You will not run into this problem when user is member of
I don't like the idea of granting
VIEW SERVER STATE to standard users.
This bug still exists in SSMS 17.1
Thank you for your interest in this question.
Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).
Would you like to answer one of these unanswered questions instead?