"View_server_state" for MS SQL

[LMeden]

Hi,

Does anybody know why you must have the permission "View_server_state" for MS SQL? It is a requirement stated in the MEGA RDMBS guide.

I have a customer who wants to know why it must be enabled.

Thanks

[edarolle · Accepted solution]

Hello LMeden,

The reason why there is a need for the VIEW SERVER STATE capability is for the MEGA program to be able to “tell”  if a transaction is currently connected or not.

MEGA is using this only for querying only the sys.dm_exec_connections view.

( http://msdn.microsoft.com/en-us/library/ms181509(v=sql.100).aspx )

Eric D