• from the database side you can see if there's still a lock on the object:

    SELECT s.host_name, s.login_name, s.status,

    DB_NAME(l.resource_database_id) AS database_name,

    OBJECT_SCHEMA_NAME(l.resource_associated_entity_id, l.resource_database_id) AS schema_name,

    OBJECT_NAME(l.resource_associated_entity_id, l.resource_database_id) AS object_name,

    l.request_mode, l.request_type, l.request_status, l.request_session_id, l.request_owner_type

    FROM sys.dm_tran_locks l

    INNER JOIN sys.dm_exec_sessions s ON l.request_session_id = s.session_id

    WHERE l.resource_type = 'OBJECT'