Erland Sommarskog (7/16/2013)
Put the statement in a stored procedure or user-defined functon. Sign the module with a certificate in master. Create login from the certificate and grant that login VIEW SERVER STATE. Grant permission to NETWORK SERVICE to the stored procedure.
Thanks for the reply! I figured out how to create a login from a certificate and how to grant it VIEW SERVER STATE. I am not sure about the following:
1) What do you mean by "Sign the module?" I looked for a way to sign the stored procedure, but couldn't find a way to do it.
2) How does this connect to the network service user? It seems like maybe I should have the stored procedure run as the user created from the certificate?