Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

table locking up??

Status
Not open for further replies.

myvision69

Programmer
Feb 3, 2006
18
US
i have a customer where one table is locked up for some reason and all access is serialized.

how can i unlock the table and allow multiuser access?

thanks
 
Its tough to answer your question, first expalin on what process its locked. If you just want to relase it, look upnder current activity or sp_who2 find the SPID and kill.

Dr.Sql
Good Luck.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top