Re: Unlocking Record

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 04/14/04 

Date: Wed, 14 Apr 2004 17:14:08 +0200

Assuming you refer to locking as in exclusive locks, shared locks etc.:

Only the connection having a log on a resource can un-lock it. If you want to do it from "outside", you need
to kill that connection. It would kill database consistency if you were able to unlock a resource that someone
else has a lock on without killing and do a rollback on that connection. 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"mikejpoole" <anonymous@discussions.microsoft.com> wrote in message
news:1C5DEFB5-756C-4A61-9E75-FD39562CC7A4@microsoft.com...
> Is it possible to unlock a record from directly inside the SQL Server MMC?

Relevant Pages

  • Re: A lot of lockings and connections to SQL Server. Is it normal or bad?
    ... probably not closing a connection in your application somewhere. ... Pro SQL Server 2000 Database Design - ... > massively attack the system with all the apps feature (purchasing, ... >> locks are fine, as long as you don't have lots of users contending for ...
    (microsoft.public.sqlserver.programming)
  • Re: SuperSocker Bind Failed on port TCP:1433 Error
    ... resources offline but not the IP resource, when you bring the SQL Server ... > We have a production server in a ISP environment running Windows 2003> / SQL Server 2000. ... > We have a lot of connection problems lately. ...
    (microsoft.public.sqlserver.server)
  • Re: A lot of lockings and connections to SQL Server. Is it normal or bad?
    ... massively attack the system with all the apps feature (purchasing, ... using SQL Server as a backend is not _that_ easy... ... > locks are fine, as long as you don't have lots of users contending for ... >> one connection?, or any other rule what should and shouldn't? ...
    (microsoft.public.sqlserver.programming)
  • RE: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
    ... These are generated when the cluster service fails to connect to SQL Server ... during its check of the resource. ... connection. ... Rand ...
    (microsoft.public.sqlserver.server)
  • Re: Dispose/Finalize
    ... the other is the native or raw connection to the sql server. ... Close calls dispose which doesn't actually do anything to the native part, ... managed resource, ...
    (microsoft.public.dotnet.framework.clr)