Hi team,
I want to know how do I find current database's transaction level on my SQL Server ?
Which table should I query to get this?
Hello @Sneha Kumari
"When using SQL Server, Azure SQL, and MySQL databases you're working at Read Uncommitted isolation level. You have multiple transactions per web request: one for writes, one for each read. "
Refer to following documentation:
https://success.outsystems.com/documentation/11/reference/outsystems_language/data/database_reference/handling_transactions/
Regards,
Pedro.
If i have changed the isolation level to read committed, is there a way to check is the isolation level was changed to read committed?
To find the current transaction isolation level for your session in SQL Server, you do not query a table directly but rather use a specific function or command.
DBCC USEROPTIONS is a command that returns a number of set options for the current session, including the transaction isolation level. You can run this command in your SQL Server Management Studio (SSMS)
Hi @Siya ,
I don't have any idea on "SQL Server Management Studio (SSMS) ". Can you tell me how to access this ?
SQL Server Management Studio (SSMS) is a tool for managing your SQL Server database and running queries in one place. For further assistance, you can contact the administrator managing the OutSystems Platform Server .