how to unloch table in sql

[mhd sbt]

hi to all i lock a table in sql with belwo query

begin tran
select * from BML.LoanApplication with(TABLOCKX)

now i want to unlock this table but i cant . i can read from this table by nolock but i want to unlock this table any help can be usefule

[Lost User]

First of all, locking has little use when selecting. Second, the lock is released as soon as the statement completes. What did you think it does?

Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]

[Corporal Agarn]

commit tran

[mhd sbt]

ok but this is when that you use COMMIT end of my related code. but i dont use COMMIT tran in my code. and if use this code you can see that this table is lock:

select * from sys.dm_tran_locks inner join sys.objects on sys.dm_tran_locks.resource_associated_entity_id=sys.objects.[object_id]

[Lost User]

mehdi.sabet wrote:

ok but this is when that you use COMMIT end of my related code.
but i dont use COMMIT tran in my code.

First, it's a lousy example; there's no way that the server can "guess" whether it should be rolled back or comitted automatically. Second, there is nothing to commit or rollback, since a SELECT statement doesn't change the data. Don't use a transaction when selecting. Also, set [XACT ABORT](http://msdn.microsoft.com/en-us/library/ms188792.aspx)[[^](http://msdn.microsoft.com/en-us/library/ms188792.aspx "New Window")] to ON. Also, don't lock an entire table, unless really, really required.

mehdi.sabet wrote:

and if use this code you can see that this table is lock:

Code to close it on SO[^]

Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]

[mhd sbt]

ok thankue