Home / server / Questions / 191661
Accepted
hyty
Asked: 2010-10-17 08:08:56 +0800 CST

What can user do with VIEW SERVER STATE permissions?

  • 772

In SQL Server 2008 there is a permissions VIEW SERVER STATE. What rights this permission give to user? What SQL Server mean by SERVER STATE?

sql-server sql-server-2008 permissions database database-administration

1 Answers

  1. Best Answer

    Read Dynamic Management Views and Functions

    Dynamic management views and functions return server state information that can be used to monitor the health of a server instance, diagnose problems, and tune performance.

    There are two types of dynamic management views and functions:

    • Server-scoped dynamic management views and functions. These require VIEW SERVER STATE permission on the server.
    • Database-scoped dynamic management views and functions. These require VIEW DATABASE STATE permission on the database.
    • 37