Logging large messages using ADO.NET appender

[Atif.Sarfraz]

Hi,

I am trying to log a large XML message whenever there is an exception in
our application. I have defined my table as follows, i.e. setting the
Message column as ntext.

CREATE TABLE [dbo].[ Log](
        [Id] [int] IDENTITY(1,1) NOT NULL,
        [Date] [datetime] NOT NULL,
        [Machine] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL,
        [Thread] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT
NULL,
        [Level] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT
NULL,
        [Logger] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT
NULL,
        [Message] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
        [Exception] [varchar](2000) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL,
 CONSTRAINT [PK_APP_Log] PRIMARY KEY CLUSTERED 
(
        [Id] ASC
)WITH FILLFACTOR = 90 ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]


Since I am not sure about the actual size of the message I have defined
the parameter as equal to 99000 characters. Is this the right way of
doing this, or is there any other way by which I can tell Log4Net to log
all the message without specifying the size here. 
(Note: My messages do get logged properly using this approach but I
don't want to give a fixed size here).

<parameter>
<parameterName value="@message" />
        <dbType value="String" />
        <size value="99000" />
        <layout type="log4net.Layout.PatternLayout">
                <conversionPattern value="%message" />
        </layout>
</parameter>

Regards,
Atif Sarfraz