Derek,

I wonder why it doesn't work the same way for you.

I am running MSSQL 2005 SP2 Developer on Win XP Pro SP2. I open SSMS, click New Query & connect to master using Windows authentication (logged in to XP with administrator credentials) & run the query

select * from sysprocesses where program_name like 'SQLAgent%'

and it returns the one row, as previously stated. I don't need to specify the "sys." in order for it to work.

Is this another Edition or config difference?