Did you try dropping it and recreating it?
JM
-----Original Message-----
From: Paul Johnston
To: Cf-Talk
Cc: Andy Ewings
Sent: 23/08/00 12:45 PM
Subject: Stored Procedure Problem
Created a stored procedure about a week ago that has been running fine
up to
now. Suddenly (for no apparent reason) it has stopped working and I
have
this error.
ODBC Error Code = S1000 (General error)
[Microsoft][ODBC SQL Server Driver][SQL Server]SqlDumpExceptionHandler:
Process 13 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION.
SQL Server is terminating this process.
What is an EXCEPTION_ACCESS_VIOLATION? Also how do I combat it.
The SP is not very complex taking in a few values (in the right order
etc)
and compiling an SQL Statement and putting the results of an
Exec(@sqlstring) on the SQL into a temp table. The table is then
returned
to Cold Fusion.
Any ideas what may not be working? It certainly used to work.
Paul
------------------------------------------------------------------------
------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
