Error: Invalid parameter 5 ('@verrormessage'):  Data type 0x23 is a deprecated large object, or LOB, but is marked as output parameter.  Deprecated types are not supported as output parameters.  Use current large object types instead.

Solution:

Step 1: Replace NVARCHAR(MAX) with NVARCHAR(4000), for example:

ALTER PROCEDURE [dbo].[usp_SendMail_NA]

                @vDistributionList VARCHAR(500),

                @vSubject varchar(30) = 'No Subject',

                @vBody NVARCHAR(MAX) = null,

                @iMailItemId int OUTPUT,

                @vErrorMessage NVARCHAR(4000) OUTPUT

AS

……

Step 2: Restart IIS with 'IISRESET'

2
3