Showing results for 
Show  only  | Search instead for 
Did you mean: 

"View_server_state" for MS SQL

MEGA Partner

"View_server_state" for MS SQL



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.



1 Reply
New Contributor

Re: "View_server_state" for MS SQL

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.

( )



Eric D