Untitled

unable to open table in sql server
Timeout Expired

Rename Failed Lock Request Time out Expired

exec sp_lock

USE master;
GO
ALTER DATABASE db SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
GO
USE db;
GO
--DO YOUR WORK HERE
GO
ALTER DATABASE db SET MULTI_USER;

select DB_NAME(1)
select OBJECT_NAME(1131151075,1)

exec sp_lock
-- locks for sesion 51
exec sp_lock 51

select DB_NAME(dbid)
select OBJECT_NAME(ObjId,dbid)

select * from sys.dm_tran_locks

select * from sys.dm_exec_connections
select * from sys.dm_exec_sessions
select * from sys.dm_tran_active_transactions
select * from sys.dm_tran_database_transactions