Re: How can I see what permissions "VIEW SERVER STATE" has?

(pshroads@xxxxxxxxx) writes:
I want to see a list of everything that granting someone VIEW SERVER
STATE permissions allows them to see. Is there a way to do that?

Search for "VIEW SERVER STATE" in Books Online. That should give you the
most of the list. I got 119 hits when I tried...



--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

Relevant Pages

  • Re: Help a newb (issue with excel, ms access and SQL Server)
    ... I can't figure it out how to do this in SQL server. ... I was using the following to create an excel file based on the select ... I believe there are some examples in Books Online. ...
    (comp.databases.ms-sqlserver)
  • Re: beware: SQL2005 management studio not 2000 compatible
    ... SQL2005 management told me that some feature was not supported on SQL 2000 ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.tools)
  • Re: Need Help Importing Data from Excel to My SQL Database
    ... The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server ... To me it sounds like SQL Server cannot find Excel at all. ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: Any help?
    ... This database used to run on NT 4.0 6 months ago. ... win2003 server. ... Have you checked the SQL Server Errorlog? ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: Login without password
    ... "Troubleshooting Orphaned Users" Topic in Books Online ... >How can I delete the login and add it back? ... >>> My SQL Server is version 7.0. ... >>> one old server to a new one, but it is still SQL Server ...
    (microsoft.public.sqlserver.security)