2012年3月8日星期四

BCP hangs: how to unlock table? without restarting server?

Hi,
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 anyway have this problem?
Thanks
MIcHi mg,
Please don't post the same question independently in separate newsgroups. I
have answered your question in .programming.
--
Jacco Schalkwijk MCDBA, MCSD, MCSE
Database Administrator
Eurostop Ltd.
"mg" <dev02@.qleave.qld.gov.au> wrote in message
news:081101c36621$32c60ce0$a601280a@.phx.gbl...
> Hi,
>
> 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 anyway have this problem?
> Thanks
> MIc
>|||Thanks Jacco for you help,
BTW. When you say
kill is that a NT command or sql server kill.
>--Original Message--
>Hi mg,
>Please don't post the same question independently in
separate newsgroups. I
>have answered your question in .programming.
>--
>Jacco Schalkwijk MCDBA, MCSD, MCSE
>Database Administrator
>Eurostop Ltd.
>
>"mg" <dev02@.qleave.qld.gov.au> wrote in message
>news:081101c36621$32c60ce0$a601280a@.phx.gbl...
>> Hi,
>>
>> 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 anyway have this problem?
>> Thanks
>> MIc
>
>.
>

没有评论:

发表评论