The sysmessage is there but since there are multiple insert stmts and multiple update stmts just looking at the placeholder is very difficult. Since in my case the support IT...

I had a requirement to get the Exact Error Messages generated by SQL Server 2000. If I was not able to achieve that then we would have switched to Windows...

I ran sp_get_message_description 515

and the O/P

Cannot insert the value NULL into column '%.*ls', table '%.*ls'; column does not allow nulls. %ls fails.

Can you tell me how to fill out the...

Hi,

Actually I had a need to get Exact Error Message and for Emailing. Since I had to give all functionality that a windows service would do.

Otherwise I would had sticked...

The URL of the file is

http://www.sqlservercentral.com/Files/sp_GetErrorDesc.sql/2268.sql

Its there in the Resources Section There's a link to download the file The File Name itself is the link Text

sp_GetErrorDesc.sql

Search for this sp_GetErrorDesc.sql

Yes I had a look. It is similar to mine. But I have not extracted any thing from it. If I had done so why would I post the article...