Any one tried to attach, using a signed stored procedure in SQL Server 2008, a certificated user with the GRANT VIEW SERVER STATE permission. I had a hack around for 5 minutes to try to get this to work, but didn't succeed.
I've temporarily granted the actual user the VIEW SERVER STATE permission, but going forward, the best solution would be to go down the signed stored procedure route.
I've temporarily granted the actual user the VIEW SERVER STATE permission, but going forward, the best solution would be to go down the signed stored procedure route.
Comment