In QA run sp_lock to find who has any locks. When you find the offending lock get the SPID number and then do a KILL spid#.

Dave

-----Original Message-----
From: Sissi Malek [mailto:[Email Address Removed] Monday, June 10, 2002 1:15 PM
To: [Email Address Removed] How to Unlock a record in SQL server 7?


Hi all,
I have a user who has a record which is locked up,
how do I unlock that record?
Your input is much appreicated,
thanks.
--
Sissi

__________________________________________________
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com

---------------------------------------------------------------------
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page