• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 430
  • Last Modified:

MS SQL - How to troublshoot and unlock objects that are locked

Hi,

I am new into SQL Databases and I want to know if you can explain to me hot to troubleshoot and lock objects that are locked within my database can I do this on Enterprise Manager I know that it is possible to write a SQL statement which can do this but you obviously need to know where the problems lie first. Please help me.

Regards,

Johan
0
johanvz1
Asked:
johanvz1
  • 2
1 Solution
 
sachinwadhwaCommented:
Database objects are unlocked once your session is disconnected.
0
 
johanvz1Author Commented:
Can you perhaps explaint to me how I can check what and where the data is that is being locked and by who?.
0

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now