User Profile

Collapse

Profile Sidebar

Collapse
sbharate
sbharate
Last Activity: Apr 18 '14, 08:41 AM
Joined: Feb 5 '14
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • sbharate
    replied to how to release a table lock..?
    in SQL Server
    Yes , Killing the process the is the answer of above question which removes the lock from table in database, but

    Offcourse , it will terminate the current process which saves my data into database.





    My Scenarion : We are processing policies and we are having concurrentConsu mers=20; so while working in concurrent environemnt,
    1st consumer will locks the table for manipulation,
    2nd consumers...
    See more | Go to post

      Leave a comment:

    • sbharate
      started a topic Remove LockacquisitionException in SQL
      in SQL Server

      Remove LockacquisitionException in SQL

      How can I avoid Lockacquisition Exception in SQL.

      My code is :
      Code:
      ALTER DATABASE <database> SET READ_COMMITTED_SNAPSHOT ON;
ALTER DATABASE <database> SET READ_COMMITTED_SNAPSHOT OFF;

SELECT is_read_committed_snapshot_on FROM
sys.databases WHERE name= 'YourDatabase'
      Which similar type of SQL quy (sic - key?) should be used to avoid Lockacquisition Exception ???

      Please help on this....
      See more | Go to post
      Last edited by NeoPa; Feb 5 '14, 03:19 PM. Reason: Edited to create an acceptable question.
      No activity results to display
      Show More
      Working...