I have modified my process in the application to recall for one time if it got failed for this specific error (50000) and now it is all set . Juntwanted...

Hi ,

I have seen an article regarding transaction Isolation.. may be the same is happening in this case and I have also found that "SET TRANSACTION" would also set to...

Hi Gail Shaw,

Yes it is the error from my application. once I have removed the functionality to handle the exceptions(RAISEERROR) and ended the error handler, I started receiving these errors...

Hi

I have removed RAISEERROR function and returned the actuall error(Select @errmsg as errmsg).. then I have tried executing 5 processes at the same time,

Now the process didnot failed at...

Hi,

As I am not aware of SQL issues in depth , We are stuck in the middle with this problem even we completed our application related development/testing... and have...

Hi,

Please find the error handler stored proc below and adivse if we can include any more fuctionality to catch the actuall error. Thank you.

USE [Devl]

GO

/****** Object: StoredProcedure [dbo].[ErrorHandler] ...

The custom Error Handler has following things,

intialized @errmsg varchar(max)

assigned ERROR_MESSAGE() value to @errmsg and returned the errmsg valuethrough RAISEERROR .

can we include any more functionalities to get the actual error...

The custom Error Handler has following things,

intialized @errmsg varchar(max)

assigned ERROR_MESSAGE() value to @errmsg and returned the errmsg value.

can we include any more functionalities to get the actual error message...

---Mohan

Hi Gail Shaw,

yes we are using ERROR_MESSAGE function in the Error handler.It has function RAISERROR(@errmsg,@severity,@state).

and the parameter @errmsg getting value from ERROR_MESSAGE function itself which still...

Hi Mike,

Thank you for your reply... Its a typo mistake in hurry.. we are using microsoft SQL only. Below is the stored procedure we are using in our application. I...