Problem when transfering an important number of records. -- sql server data warehouse

oLiVieR CheNeSoN
4/27/2005 12:00:00 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

Ray
4/27/2005 12:00:00 AM

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?

[quoted text, click to view]

sql server data warehouse : Problem when transfering an important number of records.