error message 2754

[reza assar]

hello every one! i was wrote a storedprocedure and execute it (in sqlserver 2005) this sp will get some data as parameters and after some complicated transactions delete some rows of the tables but it will complete with the following error "Msg 2754, Level 16, State 1, Procedure sp_InsertHistoryTbl, Line 30 Error severity levels greater than 18 can only be specified by members of the sysadmin role, using the WITH LOG option." 1) how can i get the error message as an admin? 2) dose any one know about this failure? 3) is there any list of error numbers (for example a list that has a table with error numbers and error messages and perhaps it`s cause and etc)? please note me any thing about these thanks!

[Mycroft Holmes]

So did you do some research or just come straight to CP. I found these responses[^] and it look like you have a locking issue, some research may provide you with a solution!

Never underestimate the power of human stupidity RAH

[reza assar]

thanks for your attention yes u right may be its better to googeling first !

[Mycroft Holmes]

Did you find a solution?

Never underestimate the power of human stupidity RAH

[reza assar]

yes i did i was wrote a rise error with 27 severity level !!!! shame on me!!!! :doh: