RE: OT - SQL Firehose mode??

2003-08-04 Thread Sarsoun, Jeff
This often happens when you open a table that has a large amount of records in the enterprise manager. The enterprise manager, to save resources will not return all the records at once and throws this error when you try to insert a record. There are several things you could do, one of them mig

RE: OT - SQL Firehose mode??

2003-08-04 Thread Ben Doom
If you open the table returning a large number of records, the SQL server goes into "firehose" mode, which basically means that it's dumping a godawful amount of data all at once. You have to wait until it is finished before you can do anything to the table. -- Ben Doom Programmer & General

RE: OT - SQL Firehose mode??

2003-08-04 Thread Robert Orlini
Got it...Thanks -Original Message- From: Ben Doom [mailto:[EMAIL PROTECTED] Sent: Monday, August 04, 2003 2:38 PM To: CF-Talk Subject: RE: OT - SQL Firehose mode?? If you open the table returning a large number of records, the SQL server goes into "firehose" mode, which

RE: OT - SQL Firehose mode??

2003-08-05 Thread Sarsoun, Jeff
This often happens when you open a table that has a large amount of records in the enterprise manager. The enterprise manager, to save resources will not return all the records at once and throws this error when you try to insert a record. There are several things you could do, one of them mig