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

  • July 7, 2010 at 9:04 am

    #1189672

    Not sure if this could be the problem.

    If I run this query I do not get a result:

    select * from master.sys.sysprocesses

    WHERE Program_Name like '%Agent%Refresher'

    But if I run this query i do get a result:

    select * from master.sys.sysprocesses

    WHERE Program_Name like '%Agent%Refresher%'

    The "%" on the end seems to make a difference.

    Thanks,

    ToddR