error 17824 - aborts my script in the middle of loop

[Masa]

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

It seems that this error has nothing to do with this weird behavior of SQL 7 - abort in the middle of a loop.

On 12/18/98 8:11:44 AM, Masa wrote:
> Hi,

I´m running the script below:

DECLARE @DTstart SMALLDATETIME,
> @DTend SMALLDATETIME
SELECT @DTstart = &#34;980801&#34;, @DTend =
> &#34;980810&#34;
SELECT &#39; processing from &#39;, @DTstart , &#39;
> to&#39; , @DTend
SELECT GETDATE(), &#39;start LOOP&#39;
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

[Lisa Ward]

On 12/18/98 8:11:44 AM, Masa wrote:
> Hi,

I´m running the script below:

DECLARE @DTstart SMALLDATETIME,
> @DTend SMALLDATETIME
SELECT @DTstart = &#34;980801&#34;, @DTend =
> &#34;980810&#34;
SELECT &#39; processing from &#39;, @DTstart , &#39;
> to&#39; , @DTend
SELECT GETDATE(), &#39;start LOOP&#39;
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

Masa - Is your maximum concurrent user connections really set to 0?