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

  • December 30, 2010 at 3:29 pm

    #1267980

    SELECT * FROM sysprocesses WHERE Program_Name like '%Refresher%' will give you the correct result..:-)