kapil_kk (7/15/2013)
Hi, while writing script I have to check that whether input value is correct or not and then display the error message for that...What I did is use RAISERROR
RAISERROR('Invalid Amount',20,1) WITH LOG
I see you are using a severity level of 20, which seems a bit excessive.
Severity levels from 20 through 25 are considered fatal. If a fatal severity level is encountered, the client connection is terminated after receiving the message, and the error is logged in the error and application logs.
