Activity overview
Latest activity by MrSuaveh
MurrayTaylor wrote:
To set the isolation level, you can issue a "SET Transaction Isolation Level statement" after you connect to SQL Server. The isolation level will apply to the rest of that session, unless you explicitly change the level again.
Within the SET Transaction Isolation Level statement, you must specify one of the isolation level.
MurrayTaylor Can you please explain how connecting to SQL Server will affect the 'SET Transaction Isolation Level' statement generated in the RedGate Migration script? / comments
MurrayTaylor wrote:
To set the isolation level, you can issue a "SET Transaction Isolation Level statement" after you connect to SQL Server. The isolation level will apply to the rest of that se...
I am having the same problem.
I changed the Transaction Isolation Level to 'Read Uncommitted' in Application Options. I see 'Read Uncommited' as the TransactionIsolationLevel in the registry. I am comparing two SQL 2012 databases that are NOT under Source Control. However SQL Compare 10 UI creates the deployment script with 'SET TRANSACTION ISOLATION LEVEL SERIALIZABLE'.
What is the purpose of the 'Transaction Isolation Level' in Tools, Application Options? / comments
I am having the same problem.
I changed the Transaction Isolation Level to 'Read Uncommitted' in Application Options. I see 'Read Uncommited' as the TransactionIsolationLevel in the registry. I a...
How to Exclude Assembly in SQL Compare Pro Command-Line?
I am using SQL Compare Pro 10.4.8 and have tried using
/Exclude:Assembly
/Exclude:Assembly:sersolsharedcode
/Exclude:Assembly AND /Exclude:Assembly:sersolsharedcode
However SQL Compare Pro keeps f...