Home Forums SQL Server 2014 Development - SQL Server 2014 SQL table locked infinity when access us from c# code RE: SQL table locked infinity when access us from c# code

  • April 20, 2016 at 7:31 am

    #1873322

    rafnunes (4/20/2016)

    thanks for your answer.

    But correct if I'm wrong, after reset SQL server Service and application the lock should not disappear?

    It's possible to know if a table is locked, or the state?

    Thanks again.

    After restarting the SQL Server service, which is a rather brutal technique for a production server, the locks should disappear.

    To start investigating locks and who is locking, I suggest that you read up on sys.dm_tran_locks and sp_who2.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.