|
Home > Archive > MS SQL Data Warehousing > April 2005 > Problem when transfering an important number of records.
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Problem when transfering an important number of records.
|
|
| oLiVieR CheNeSoN 2005-04-27, 7:23 am |
| 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
| |
|
| 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?
"oLiVieR CheNeSoN" <ocheneson@hotmail.com> wrote in message
news:ub65iUySFHA.336@TK2MSFTNGP09.phx.gbl...
> 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
>
>
>
>
|
|
|
|
|