Is there anyway to provide either the activity monitor or "read" access to what is happening on a sqlserver (2005) without being a sys admin? the following is the answer.
The rights are:
1) Permissions (Open Server Properties then select Permissions)
ALTER TRACE
CONNECT SQL
VIEW ANY DATABASE
VIEW ANY DEFINITION
VIEW SERVER STATE
2) Server roles
Public
3) Database Roles
public (all databases)
db_datareader (all databases)
SQLAgentUserRole (msdb only)
The ALTER TRACE authority is only needed if you want to allow members of the Windows group to run traces.