Hi

Go to sql enterprise manager, expand current activity
icon, look in locks and find required process and kill
it by selecting and right clicking the mouse
properties or send a message to that user to release
it.

Regards
San


--- Sissi Malek <[Email Address Removed] wrote:
> 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] For additional commands, e-mail:
> mssqldba-[Email Address Removed]


__________________________________________________
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
MS Sql Server LazyDBA home page