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
MortarelloAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
jogosConnect With a Mentor Commented:
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
 
OCDanConnect With a Mentor Commented:
This article should help:
SQL locks
0
 
MortarelloAuthor Commented:
Tks guys
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.