Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Note

Tested SQL Server Collations:

  • SQL_Latin1_General_CP1_CS_AS
  • SQL_Czech_CP1250_CS_AS

Be aware that using CS (case-sensitive) collation causes column names in queries to be case-sensitive too!

Database create

Code Block
languagesql
linenumberstrue
CREATE DATABASE [midpoint] 
COLLATE SQL_Latin1_General_CP1_CS_AS

ALTER DATABASE "midpoint" SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
ALTER DATABASE "midpoint" SET ALLOW_SNAPSHOT_ISOLATION ON;
ALTER DATABASE "midpoint" SET MULTI_USER;

CREATE LOGIN midpoint WITH PASSWORD = 'password'
USE [midpoint]
CREATE USER [midpoint] FOR LOGIN [midpoint] WITH DEFAULT_SCHEMA=[dbo]
ALTER ROLE [db_owner] ADD MEMBER [midpoint]

...