DECIMAL(38) is what we used. No issues so far. 

Thanks,
Paul

On Nov 27, 2014, at 11:44, Dário Abdulrehman <dario.rehman@gmail.com> wrote:

Hi,

The change that is documented in the mssql.sql script
https://github.com/qos-ch/logback/blob/edc0fe2340782a592f9fd8329287d8ea5557b09c/logback-classic/src/main/resources/ch/qos/logback/classic/db/script/mssql.sql

as "The event_id column type was recently changed from INT to DECIMAL(40) without testing."
does not work in MS SQL Server 2008 R2.

It issues the following error:

Column or parameter #15: Specified column precision 40 is greater than the maximum precision of 38.

Changing the mentioned fields to DECIMAL(38) fixes the problem but perhaps it is better to revert back to INT?

Thanks,
Dário


_______________________________________________
Logback-user mailing list
Logback-user@qos.ch
http://mailman.qos.ch/mailman/listinfo/logback-user