IEA Software, Inc.

IEA Software Knowledge Base - ID:59292

IEA Knowledge base

Emerald Report (KB ID: 59292)

Jul 21 2011

When I click 'Current Activity' button from Emerald Admin / Database menu only the current process is displayed. How can this be changed to show all processes?

Jul 21 2011

This occurs when user Emerald uses to authenticate to the database does not have the 'view server state' permission. To grant this right take the following steps:

Open a query tool logging into the database as sa
Switch to master database
Execute the query: GRANT VIEW SERVER STATE to emeralduser

'emeralduser' is the user account Emerald is currently using to attach to the database.

If the grant command fails contact your DBA for assistance.