Is there anyway to unlock tables that BCP has locked. I
was running the BCP command thru sql analyser, and it hung
and could not cancel it. I Exited sql analyser. Tables
still locked. How do i unlock them.
I think bcp locked a file on the file system as well?
When we go to system activity Enterprise manager, it times
out. If we restart server the the tables are unlocked.
Q1) is there a way to unlock a table without restarting
the SQL server.
We think its being caused by bcp, locking a file on the
system? not sure
Q2) Do anyone else has this problem?