Connecting Tech Pros Worldwide Forums | Help | Site Map

Using raiseerror

Newbie
 
Join Date: Mar 2007
Posts: 2
#1: Mar 7 '07
Hi Maybe I've got the wrong end of the stick, I sort of thought that I could user raiserrror in an SQL statment to write to the SQL error Log:

i.e. hittin f5 in Qery analyser with the statement

RAISERROR ('some test here.', 16, 1, 'more test')

would create an entry in the SQL error Log

Where am I going wrong please?

Newbie
 
Join Date: Oct 2008
Posts: 1
#2: Oct 24 '08

re: Using raiseerror


RAISERROR ('some test here.', 18, 1, 'more test') with LOG

Edit the 18 to below 16 to stop it aborting.

Edit it to above 20 to terminate the SQL session.
Reply