At 19/11/2002 08:33 AM, you wrote:

>Further information: the database server is dedicated to a single
>database. Also, the database operation that coincided with the crash
>was the execution of a stored procedure (using "execute procedure"
>syntax) which contained a single insert statement followed by
>a "SUSPEND" statement. There are no recursive procedures and no
>UDF's or custom collation drivers are used.

When using "execute procedure", don't use "SUSPEND" in the stored
procedure. SUSPEND is used to return values when using the stored
procedure in a SQL-DML statement(i.e. SELECT). This could be a bug in the
database server for not recognizing the error and raising a friendlier
error message, instead of crashing the server. It is a bug if you can
reproduce it as many times as you want. Try creating another database and
try to reproduce it, I suggest you use a test computer for this. Report
back here with your results.


Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.accramed.ca)