Microsoft SQL specifics

SQL user

Create MS SQL user using SQL authentication and not Windows one. Set default language for this user to English.

When creating database for EBA DMS the following instructions must be considered since they are crucial for EBA DMS functioning:

Set Collation on:

“Language_CI_AS”. Collation must have CI – character insensitive.
Language English is preferred.

Preventing deadlocks:

When new database is created, before using it execute SQL queries as database administrator (sa):

ALTER DATABASE MyDatabase SET ALLOW_SNAPSHOT_ISOLATION ON 
ALTER DATABASE MyDatabase SET READ_COMMITTED_SNAPSHOT ON

Replace “MyDatabase” with actual EBA DMS database name.

SQL queries must not be executed simultaneously(execute one and when its done start the other one), and must be executed on each database in case you are using more databases for EBA DMS.

Before SQL queries are executed all EBA DMS users must close EBA DMS client including the one on the server, because the second query will not proceed otherwise.

Enable document locking

Every time a user opens a document that document becomes locked for other users, but they can view the document in read-only mode.

To enable the document locking two SQL queries must be executed, and must not be executed simultaneously:

USE master GRANT VIEW SERVER STATE TO SqlUser

Replace “SqlUser” with actual sql user which uses EBA DMS database. Execute SQL queries as a user with access to master database (sa).

Prevent large log files

MS SQL server by default records very detailed data in the log files. That means that log files become large and occupy a lot of disc space. To avoid this situation set database log option to “simple”. This can also be done by executing SQL query:

ALTER DATABASE YourDatabaseName SET RECOVERY SIMPLE

Replace “YourDatabaseName” with actual database name for EBA DMS.