Dear Reader Today one of my client shows me the problem that is new for me and i need to share with you that issue is when they are trying to update or insert any stuff in the sql server by using begin transection they are unable to access the table let suppose there are thosands of tables that need to be updated under begin transection then it must lock the sql tables unless untill the transection has not be committed or rollback begin transaction update tablenameset columnname = getdate() where columnname = '9000000017' Commit Solution for this problem I have found the solution may be it works for current basis i am not able able to sure this will work but that is what they are looking http://msdn.microsoft.com/en-us/library/ms173763.aspx Regards Rashid Imran Bilgrami CEO Best visualization http://www.bestvisualization.com