sp_lock 

select object_id('TABLE_NAME') 

select object_name('OBJECT_ID')