Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Lost connection on large process

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-10-25 : 08:53:37
Andres Rojas U. writes "Dear Sir:
My name is Andres Rojas, I from Chile.
I'm develop in Sql Server 2000 (Windows 2003 Server). I develop a Stored Procedure that calculate Correlations from any tables. This process generate 2 tables of 50 million o records, but (in aleatory way) this process stop the Server, the sevices running not responses, the communications is lost, etc. The computer should be rebooted. The Computer is a Pentium 4 win 203 Gb HD and 1 GB Ram."

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2004-10-25 : 12:11:08
do you have code you can post for us to look at? also, do you have the DDL for the underlying tables that you are querying?



-ec
Go to Top of Page
   

- Advertisement -