[Quickfix-users] ODBC logs, maxmessagesize, TEXT datatype in SQL Server, and DELETE triggers

[George M. C. <geo...@qu...>]

Hi,
   I am using the ODBC mesage log, and my underlying database is SQL 
Server 2000. I realized during my testing that the messages logged in 
the messages table of my buy-side logs were getting deleted upon each 
reset. I was planning on writing a DELETE trigger to copy those rows 
over to a parallel table that I can use to archive those messages 
permanently, but SQL Server does not support the use of  columns of TEXT 
datatype in triggers.

Is it absolutely necessary to use TEXT in this column instead of a 
slightly smaller variable-length character datatype like varchar? I know 
that this may be a limitation specific to SQL Server.

Do you recommend the use of field 383, sent during the logon, to limit 
the size of all messages to some value like 8k? What is the reasonable 
limit that one might expect for real-world FIX messages?

thx
George Coles