Just for info

I get the same bug.

the problem was the password of sql Agent was changed.

make sure that the sql agent account it still ok : for this just restart...

try this:

set nocount on

declare @spid varchar(10)

declare @blkby varchar(10)

declare @stmt varchar(100)

create table #temp

( spid integer, status varchar(100), login varchar(50), hostname varchar(25), blkby varchar(10),

...