How to set SQLException Number

sql-server sqlexception raiserror
Sharles Phirans picture Sharles Phirans · Dec 7, 2011 · Viewed 10.7k times · Source

I'm having an issue on settin up SqlException.Number

On my Stored Proc i'm raising an error

--@number = 50001

RAISERROR(@number, 16, 1) -

I should expect that the Error_Number() should be @number but I always get 18054

Is there something wrong with my RAISERROR?

Answer

denolk picture denolk · Dec 7, 2011

Check the sys.messages table for error code 74601. if this is a user defined error, it shouold be added in the table.

for any error that is greater than 50000 should give you this output if not found.

Msg 18054, Level 16, State 1, Line 1
Error XXXXX, severity 16, state 1 was raised, but no message with that error number was found in sys.messages. If error is larger than 50000, make sure the user-defined message is added using sp_addmessage.

Related questions

java.sql.SQLException: No suitable driver found for jdbc:microsoft:sqlserver

I'm getting this exception when I try to run this program. It's one of the Microsoft examples. I've added the sqljdbc4.jar to the classpath in netbeans for both compile and Run, via the project properties. I also tested that …

Read More
conversion of a varchar data type to a datetime data type resulted in an out-of-range value

I have the following piece of inline SQL that I run from a C# windows service: UPDATE table_name SET status_cd = '2', sdate = CAST('03/28/2011 18:03:40' AS DATETIME), bat_id = '33acff9b-e2b4-410e-baaf-417656e3c255…

Read More
Can't connect to SQL Server database: Login failed for user 'sa''

I can't simply connect to my database because of this error Login failed for user 'sa' Consider these lines of code: SqlConnection conn = new SqlConnection("Data Source=arohbi;Initial Catalog=SPADA_FIS;Persist Security Info=True;User ID=sa;Password=…

Read More