DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: table lock in past

  1. #1
    Join Date
    Apr 2009
    Posts
    54

    table lock in past

    Hi Guys,

    is there any query which gives which table had been locked in past i mean some hours ago or 1 day ago?.if so please send me the query. thanks a lot in advance.


    Best Regards.

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    You can try turning on auditing. But I am not aware of any table that will show the history of what tables have been locked.
    you can certainly look in real time to see what is locked. And you can create a job to log anything that is locked when the
    job runs. But auditing is likely you best option.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width