Skip to main content

Posts

Showing posts from April, 2010

Unable to access the table during begin transection

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