Comments
Sort by recent activity
Found the key in my registry: TransactionIsolationLevel and it is set to 'READ COMMITTED'. So that seems fine. / comments
Found the key in my registry: TransactionIsolationLevel and it is set to 'READ COMMITTED'. So that seems fine.
I'm using the GUI only.
I set the option under Tools, Application options to 'READ COMMITTED' and then create a new project, compare to databases, generate a script and the script then starts by setting the transaction isolation level to SERIALIZABLE.
BTW, I'm using SQL Compare Pro version 10.4.8.87.
Example output:
/*
Run this script on:
server1\instance1.database1 - This database will be modified
to synchronize it with:
server2\instance2.database1
You are recommended to back up your database before running this script
Script created by SQL Compare version 10.4.8 from Red Gate Software Ltd at 9/5/2013 8:34:01 AM
*/
SET NUMERIC_ROUNDABORT OFF
GO
SET ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT, QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
IF EXISTS (SELECT * FROM tempdb..sysobjects WHERE id=OBJECT_ID('tempdb..#tmpErrors')) DROP TABLE #tmpErrors
GO
CREATE TABLE #tmpErrors (Error int)
GO
SET XACT_ABORT ON
GO
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
GO
/ comments
I'm using the GUI only.
I set the option under Tools, Application options to 'READ COMMITTED' and then create a new project, compare to databases, generate a script and the script then starts by se...
Thanks for that ftp server!
I'll check if I can open the snapshots with an earlier build! / comments
Thanks for that ftp server!
I'll check if I can open the snapshots with an earlier build!
It took me a while to find the correct version, but using version 10.2.0.696 did the trick!
Thanks for your help James! / comments
It took me a while to find the correct version, but using version 10.2.0.696 did the trick!
Thanks for your help James!