[logback-user] MS SQL Server script error

[Dário Abdulrehman]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.qos.ch/pipermail/logback-user/attachments/20141127/267da574/attachment.html>