I need a user to have access to track all processes logged into our
SQL Server. In other words, I need them to be able to query
master.dbo.sysprocesses. I've already written the query they'll use,
and it works when logged in as sa, but not when logged in as the user
who needs to be able to do this.
I know that on SQL Server 2005, the syntax to grant this permission
would be:
grant view server state to <username>
Unfortunately, I need to do this on an older server running SQL Server
2000, and that syntax doesn't work to grant the permission. Any idea
what I'd need to grant the user to make this work?
Thanks in advance,
--Richard