Need to store SQL error code in debug table

Finding a good web host for your database sites is a big problem. Check our recommended host for database hosting or the datacenters with the most powerful and reliable dedicated servers suited for large databases.

This databases discussion was started by surjyakp on 10 February 2010

I have one table having column dbg_lvl and dbg_msg.
Let say i executed some update sql statement in stored perocedure which has some eror. e.g. it threw the error like
SQL0150N The target fullselect, view, typed table, materialized query table,
or staging table in the INSERT, DELETE, UPDATE, or MERGE statement is a target for which the requested operation is not permitted. SQLSTATE=42807
Now I want to store 42807 in dbg_lvl column and the message “SQL0150N The target fullselect, view, typed table, materialized query table,
or staging table in the INSERT, DELETE, UPDATE, or MERGE statement is a target for which the requested operation is not permitted” in dbg_msg column.

Learnmore Microsoft SQL Server databases hereShould you need to go for trustworthy hosting services for all database related sites, we suggest this host for virtual database hosting and this one for dedicated databases hosting