Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Table Unlocking

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-11-19 : 23:03:55
barmalej writes "A database application when starting sets a lock on a table.
SP_LOCK gives information that Type=TAB, Mode=IS and Status=GRANT.
Is it possible to temporarily unlock the table either from within the application itself or by calling a Stored Procedure, etc.? I want to make changes in the table.
I cannot control the initial locking.
Thank you for the answer."
   

- Advertisement -