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.
Go to Solution.
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 )