Hi,

I´m running the script below:

DECLARE @DTstart SMALLDATETIME, @DTend SMALLDATETIME
SELECT @DTstart = "980801", @DTend = "980810"
SELECT ' processing from ', @DTstart , ' to' , @DTend
SELECT GETDATE(), 'start LOOP'
DO WHILE @DTstart <= @DTend
BEGIN
exec p_pmp_charg_unif_csg @DTstart
WAITFOR DELAY &#34;00:01:00&#34;
SELECT @DTstart = DATEADD(DAY,1,@DTstart )
END
SELECT GETDATE(), &#39;start LOOP&#39;

I´m having the following problem with SQL 7.
When running the loop, all in a sudden it stops - there´s no
error message on result.
But checking out the current error log, I´ve found the error 17824
reported .

According to the BOL, this error is related to &#39;priority boost&#39; and
troubles in connection between server and client.

This SQL server 7 has the following configuration:

- 128Mb of RAM, and SQL7 can use from 0 to 128MB
- boost SQL Server priority on Windows NT
- maximum concurrent user connection is 0

Is there someone that had similar problem in SQL 7?

TVMIA

Masa