Home Forums SQL Server 2005 T-SQL (SS2K5) SELECT * FROM master.sys.sysprocesses WHERE program_name = N'SQLAgent - Generic Refresher' not returning any results though SQL Server Agent is running RE: SELECT * FROM master.sys.sysprocesses WHERE program_name = N'SQLAgent - Generic Refresher' not returning any results though SQL Server Agent is running
Sakthivel Chidambaram
SSCertifiable
Points: 5531
More actions
December 19, 2008 at 12:28 am
#915014
Hi Jack,
Buy my case is SQL Server Agent is running but the entry is not there in sysprocesses...
Regards,SakthiMy Blog -> http://www.sqlserverdba.co.cc