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 21, 2008 at 4:57 am
#915819
oh.... that was a big type error... I have edited my post... Thanks for that...
Actually I was trying to say that after restarting SQL Server now it is visible in sysprocesses....
Regards,SakthiMy Blog -> http://www.sqlserverdba.co.cc