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

"View_server_state" for MS SQL

Solved
Highlighted
MEGA Partner

"View_server_state" for MS SQL

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

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.

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

 

 

Eric D