Hello experts

Facings DB locking problem in sql server 2000
Is there any way to release lock on db objects by there Name

i have two set of stored procedure when i run those stored procedure in
different batches they work fine
but i have to call those stored procedure in one batch by set of triggers
i just want to know that is there any way to release some table from lock
say release lock "Table name "







Thanks & Regards,

Moazam Shaharan
Software Engineer.
NetSol Technologies Inc.
NetSol IT Village
NetSol Avenue, Ghazi Road
Lahore Cantt. 54792, Pakistan.
Tel: +92 42 111 44 88 00 (Ext. 510)
Mob: +92 300 6848200
Fax: +92 42 572 6740


DISCLAIMER: This e-mail and any file transmitted with it is confidential and intended solely for the use of the addressee. If you are not the intended recipient, you are notified that disclosing, copying, distributing or taking any action regarding the contents of this information is strictly prohibited. If you have received this email in error, please return the original to the sender and destroy the same immediately. Any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.
WARNING: The recipient should check this email and any attachment for the presence of viruses. Although the company has taken reasonable precautions to ensure no viruses are present in this email, the company does not accept responsibility for any loss or damage arising from the use of this email or attachment.


MS Sql Server LazyDBA home page