Works in debug mode, does not when i run without debug

Hi,

I had a question. When I try to synchronize a table, it works when I run in debug mode (F5) but does not when I run it without debug (Ctrl F5). Following is the SQL generated in run mode when I call block.GetString method.

please note that no inserts updates or delete SQL statements are generated between BEGIN TRANSACTION and COMMIT TRANSACTION.

Works perfectly in debug mode.

Please help as soon as possible. Thank You!!

*********************************
Script created by SQL Data Compare version 7.1.0.230 from Red Gate Software Ltd at 12/16/2009 15:23:06

Run this script on meckcamadev\sql2k5dev.cama_apro2009_shell

This script will make changes to meckcamadev\sql2k5dev.cama_apro2009_shell to make it the same as meckcamadev\sql2k5dev.cama_apro2009_source

Note that this script will carry out all DELETE commands for all tables first, then all the UPDATES and then all the INSERTS
It will disable foreign key constraints at the beginning of the script, and re-enable them at the end
*/
SET NUMERIC_ROUNDABORT OFF
GO
SET XACT_ABORT, ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT, QUOTED_IDENTIFIER, ANSI_NULLS, NOCOUNT ON
GO
SET DATEFORMAT YMD
GO
-- Pointer used for text / image updates. This might not be needed, but is declared here just in case
DECLARE @pv binary(16)

BEGIN TRANSACTION

COMMIT TRANSACTION
GO
*********************************