Error: 14667, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there wa

When you use Database mail in SQL server you receive the following error message:

Error: 14667, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped

This is a confirmed bug since SQL Server 2005 and should have been solved in later versions, but it’s not. The bug is still there!

 The errror occurs because the sp_readrequest stored procedure uses an incorrect parameter.

The solution according to Microsoft (http://support.microsoft.com/kb/931175) is to change the inccorect code in sp_readrequest.

1. Start SQL Server Management Studio, and then connect to the instance of SQL Server 2005.
2. In Object Explorer, locate and then right-click the following object:
   DatabasesSystem DatabasesmsdbProgrammabilityStored Proceduresdbo.sp_readrequest
3. Click Modify.
4. Locate the following line of code.

   SET @localmessage = FORMATMESSAGE(14667, convert(NVARCHAR(50), @mailitem_id))

5. Replace the existing line of code by using the following line of code.

   SET @localmessage = FORMATMESSAGE(14667, @mailitem_id)

6. On the Query menu, click Execute.

It looks like a simple fix.,but it isn’t it fixed in any service pack so far. Please vote for a fix at :https://connect.microsoft.com/SQLServer/feedback/details/625096/syntax-error-in-sp-readrequest-prevents-proper-error-and-can-halt-db-mail

/Håkan Winther

COO