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

Thanks,
Paul

On Nov 27, 2014, at 11:44, D?rio Abdulrehman 
<[email protected]<mailto:[email protected]>> 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
[email protected]<mailto:[email protected]>
http://mailman.qos.ch/mailman/listinfo/logback-user
_______________________________________________
Logback-user mailing list
[email protected]
http://mailman.qos.ch/mailman/listinfo/logback-user

Reply via email to