Histórico da Página
Index
Índice | ||||||||
---|---|---|---|---|---|---|---|---|
|
Approved versions of SQL Server
To check the approved versions of Microsoft SQL Server, go to the Portability Matrix
Database creation
Fluig requires a database with Latin1_General_CI_AS encoding. To create the database with this characteristic, log in to SQL Server with the user that will be used by Fluig and run the following SQL command:
Bloco de código | ||
---|---|---|
| ||
CREATE DATABASE database_name COLLATE Latin1_General_CI_AS; |
Where database_name is the name of the database to be created.
Another alternative for the creation of the database is to use the Microsoft SQL Server Management Studio, following these steps:
Deck of Cards | ||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||||||||
|
Database configuration
After creating the database, you need to perform the following checks:
Database Owner
The user used by Fluig to connect to the database should be the owner (db_owner) of the database used by Fluig. To check which user is the database owner, run the following SQL command:
Bloco de código | ||
---|---|---|
| ||
SELECT suser_sname(owner_sid) FROM sys.databases WHERE name = 'database_name'; |
Where database_name is the name of the database to query the owner.
If the database owner is not the user used by Fluig to connect to the database, run the following T-SQL command to define this user as owner (db_owner):
Bloco de código | ||
---|---|---|
| ||
USE database_name EXEC sp_changedbowner 'user_name'; |
Where database_name is the database name and user_name is the user who will become the database owner.
Changing the isolation level
To check if the isolation option READ_COMMITTED_SNAPSHOT is enabled for the database, run the following SQL command:
Bloco de código | ||
---|---|---|
| ||
SELECT is_read_committed_snapshot_on FROM sys.databases WHERE name= 'database_name'; |
Where database_name is the name of the database to query the owner.
If the return of the previous query is the value 0, you need to run the following SQL command:
...
Where database_name is the name of the database to be used for Fluig.
...
This SQL Server standard isolation level change operation is performed automatically by Fluig. However, it is important to pay attention to the following factor:
...