Problem with big transfer

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
OlivierHi
How do you transfer the data?
"oLiVieR CheNeSoN" <ocheneson@.hotmail.com> wrote in message
news:e4t6$UySFHA.628@.tk2msftngp13.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
>
>|||Using UPDATE table set (select ...) with T SQL
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ORiGwYySFHA.2916@.TK2MSFTNGP15.phx.gbl...
> Hi
> How do you transfer the data?
> "oLiVieR CheNeSoN" <ocheneson@.hotmail.com> wrote in message
> news:e4t6$UySFHA.628@.tk2msftngp13.phx.gbl...
> hangs.
>|||Hi
I have just finished test to UPDATE table with 200K rows and have not met
any problems.
Do you update a PK also?
What is about memory? 2GB or more?
"oLiVieR CheNeSoN" <ocheneson@.hotmail.com> wrote in message
news:OBSJ$kySFHA.1384@.TK2MSFTNGP09.phx.gbl...
> Using UPDATE table set (select ...) with T SQL
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:ORiGwYySFHA.2916@.TK2MSFTNGP15.phx.gbl...
>sql