message(1500) to message(max) please

Jun 5, 2011 at 2:50 PM

Please change all message nvarchar(1500) to message nvarchar(max) to prevent truncation of message strings longer than 1500 characters.

I think there are at least two, probably more places in various SQL scripts and code that will need to change.

Coordinator
Jun 23, 2011 at 4:28 AM

Thanks, thats a valid suggestion

Jun 23, 2011 at 10:50 AM

Here are the two places that need to change:

CREATE TABLE [dbo].[Log](

   [Message] [nvarchar](1500) NULL,

CREATE PROCEDURE [dbo].[WriteLog]
(
 @Message nvarchar(1500),

Both areas need to change to nvarchar(max)