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

Locks on SqlServer

Guys

I was running a method on c# against Sqlserver and the I stoped my App but some table is still locked.

Does any one could help me how to release those locks ?

Many Thanks
0
Mortarello
Asked:
Mortarello
2 Solutions
 
OCDanCommented:
This article should help:
SQL locks
0
 
jogosCommented:
Article is on 'how to find' locks.

When you found that the locks are from a session that was from your stopped App then you only can get rid of it by killing the hanging session.
http://msdn.microsoft.com/en-US/library/ms173730(v=sql.105).aspx

And take in concideration that stopping an App may not leave sql sessions allive.
0
 
MortarelloAuthor Commented:
Tks guys
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

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