The schema initialization SQL string (https://github.com/NEventStore/NEventStore.Persistence.SQL/blob/master/src/NEventStore.Persistence.Sql/SqlDialects/MsSqlStatements.resx) has a bug: it uses "SYS.types", however, it should actually use "sys.types" (casing!). By default that is not immediately a problem, as the default collation of SQL Server is case insensitive. As soon as you use a collation which is not case insensitive (we need that for our application), the script fails.
Fix: simply use the correct schema "sys" instead of "SYS".
The schema initialization SQL string (https://github.com/NEventStore/NEventStore.Persistence.SQL/blob/master/src/NEventStore.Persistence.Sql/SqlDialects/MsSqlStatements.resx) has a bug: it uses "SYS.types", however, it should actually use "sys.types" (casing!). By default that is not immediately a problem, as the default collation of SQL Server is case insensitive. As soon as you use a collation which is not case insensitive (we need that for our application), the script fails.
Fix: simply use the correct schema "sys" instead of "SYS".