Few quick checks for DB objects and locks

exec sp_lock

exec sp_who 85

exec sp_who2 85

DBCC INPUTBUFFER (85)

select * from sys.sysprocesses where blocked > 0

select * from master.dbo.syslockinfo

SELECT * FROM master.sys.dm_tran_locks

select db_name(1)

select object_name(786101841)

SELECT * FROM master.sys.objects where object_id = 1115151018

select * FROM dbo.sysobjects where id=1115151018

exec sp_help 'Subjects'

select * from sysobjects where name like 'Subjects'