[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 264
  • 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

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

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