Audit not working with MSSQL DB & default collation not set to SQL_Latin1_General_CP1_CI_AS

Configured Audit events are not visible in the Audit dashboard. The following error message is logged in the log file loader-messages.log

[TRACE] [03/19/2014 09:13:53.346] [2672] [ZENLoader] [63] []
[Loader.AuditEventStorerModule] [] [Caught exception while processing event
filesjava.sql.SQLException: java.sql.SQLException: Cannot resolve the collation
conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in
the equal to operation.
   at
com.novell.zenworks.datamodel.audit.utils.SettingsBatchProcessor.getSettingsFromDB(SettingsBatchProcessor.java:191)
   at
com.novell.zenworks.audit.loader.modules.auditeventstorer.LoaderAuditParserEventHandler._loadEventSettings(LoaderAuditParserEventHandler.java:246)
   at
com.novell.zenworks.audit.loader.modules.auditeventstorer.LoaderAuditParserEventHandler.endBatchProcessing(LoaderAuditParserEventHandler.java:135)
   at
com.novell.zenworks.audit.loader.modules.auditeventstorer.AuditEventStorerModule.run(AuditEventStorerModule.java:271)
   at com.novell.zenworks.loader.ZENModuleThread.run(ZENModuleThread.java:112)
Caused by: java.sql.SQLException: Cannot resolve the collation conflict between
"SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to
operation.

When the Audit database is precreated but not set to SQL_Latin1_General_CP_CI_AS, configured events will not be logged. As a result the dashboard will remain empty.