Activity overview
Latest activity by JosvanDuijn
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...
Setting for transaction isolation level not used in script
Hi,
When i set the transaction isolation level to READ COMMITTED under Tools, Application Options, and create a new compare project, the setting is not used in the generated scripts. Instead the tr...
Commit changes tab error: unexpected token
Hi,
I'm trying to setup SQL Source Control 3.4.8.18.
I've added a couple of database successfully, but on one database I get the following exception, but it does not specify which file has the prob...
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!
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!
Unable to read beyond the end of the stream
Hi,
When trying to open a snapshot of a database that I have made with a previous build of SQL Compare 10, I get the error "Unable to read beyond the end of the stream".
I am currently running SQL ...
File tables are not scripted properly
When you compare a database with file tables (new SQL 2012 feature) they are not scripted properly!
I tested this with version 10.1.10.102.
How it is scripted now:
CREATE TABLE [dbo].[BOOKING_INVOI...
Support for SQL Server 11 (Denali)
Is it possible to get SQL Prompt 5 to work with the SQL Server Management Studio for the CTP version of SQL 11 (Denali)?
I installed the latest version, and it show in VS 2010 but not in the new ve...