Problem when transfering an important number of records.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

oLiVieR CheNeSoN - 27 Apr 2005 13:32 GMT

Hi,

I have MSSQl 2000 , SP3 with WIn2000

when I transfer from one table to another, 115852 records, le server hangs.

I tried with 70000 records and it worked. even with 90000 records.

With more than 90000 records, the server hangs.

Any idea ? It might be a bug in MSSQLsvr ? any known bugs ?

Thanks for your help

Olivier

Reply to this Message

Ray - 27 Apr 2005 23:51 GMT

Oliver,

We will need more information to help guide you.

How are you transfering the data? Insert, select into, DTS, bcp, etc.
Describe what you mean by hang.
Can you connect?
If you can connect what is showing for the spid when excuting an sp_who2
active?
Is the sqlserver process consuming cpu and disk?
Is there anything in the SQL Error log?

> Hi,
>
[quoted text clipped - 12 lines]
>
> Olivier

Reply to this Message