Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary.
Total Post History
7-Day Post History
- New Posts:
- New Topics:
- Active Topics:
Our newest member
All times are UTC [ DST ]
I'm running the tool on a Sql 2008R2 database and get the error attached.
I'm assuming that it's because I only have access to the database & not the server.
- Posts: 20
- Joined: Fri Oct 15, 2010 7:11 pm
"Requires VIEW SERVER STATE permission on the server."
http://technet.microsoft.com/en-us/libr ... 87743.aspx
This SQLCop check should be looking for the appropriate permissions prior to running the check. Ideally, SQLCop would return something like, "You do not have the appropriate server privileges for this check."
Thank you for bringing this to my attention.
- LTD Admin
- Posts: 2369
- Joined: Tue Oct 09, 2007 5:19 pm