Access Violation Errors

[fogal]

In event log I am geting errors:

Error: 0, Severity: 19, State: 0

language_exec: Process 57 generated an access violation. SQL Server is terminating this process.

Error: 0, Severity: 19, State: 0

SqlDumpExceptionHandler: Process 57 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.

What Can I do to resolve this ? Urgent. How can I find out what is causing these errors.

 

[SQLBill]

In Enterprise Manager, drill down to Management, expand Current Activity. Click on Processes. Find the process id (SPID) that matches the Process number in the error message.

What application is that? What did it run at the time of the error?

-SQLBill

 

[freshegg]

Error: 0, Severity: 19, State: 0
SqlDumpExceptionHandler: Process 75 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.

I am getting this error in event viewer every time we run a certain action. when set nocount property is not explicitly turned on and off at the start and end of stored procedures there can be problems, have tried adding that into the Store Procedure but we don't get the desired response returned from the execute!
anyone got any ideas?

thanks