Also, in the 2008 AM, the SessionID 66 shows the command as blank, but when
I do a right click and select details, I get as the last command:

(@_msparam_0 nvarchar(4000),@_msparam_1 nvarchar(4000),@_msparam_2
nvarchar(4000),@_msparam_3 nvarchar(4000),@_msparam_4
nvarchar(4000),@_msparam_5 nvarchar(4000))SELECT
p.name AS [Name]
FROM
sys.all_objects AS sp
INNER JOIN sys.all_parameters AS param ON param.object_id=sp.object_id
INNER JOIN sys.extended_properties AS p ON p.major_id=param.object_id AND
p.minor_id=param.parameter_id AND p.class=2
WHERE
(param.name=@_msparam_0)and((sp.type = @_msparam_1 OR sp.type = @_msparam_2
OR sp.type=@_msparam_3)and(sp.name=@_msparam_4 and
SCHEMA_NAME(sp.schema_id)=@_msparam_5))
ORDER BY
[Name] ASC

But in 2005 AM, the ProcessID shows the command as blank but right clicking
and selecting details shows the Last Command as blank.

Thanks,

Tom

sp_who2 should show you want you want to know. But try placing the db in
single user mode with the ROLLBACK IMMEDIATE option to kill any open
connections.