Progress % display issue
jmeyer
Posts: 70 Bronze 2
When refreshing tables in the "tables & views" dialog box I regularly see the progress indicators display percentages of more than 100% in some case 5000% and more. I can reproduce this by running the script below in the TEMPDB of two servers and then have DataCompare refresh the tales/views list. I apologize for the long script
USE tempdb; GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO IF EXISTS ( SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Test]') AND type IN (N'U') ) DROP TABLE dbo.Test; GO CREATE TABLE [dbo].[Test]( [WHSE_ID] [int] IDENTITY(1,1) NOT NULL, [BSSN] [char](9) NULL, [SEQ] [tinyint] NULL, [grcend] [date] NULL, [MOSDISGR] [tinyint] NULL, [TERMEND] [date] NULL, [TERMBEG] [date] NULL, [GUARREF] [varchar](12) NULL, [ORIGSCL] [char](8) NULL, [SCYPGA] [char](2) NOT NULL, [SCYPGATXT] [varchar](20) NOT NULL, [PROGRAM] [char](6) NOT NULL, [REGCAT] [char](7) NOT NULL, [LENDER] [char](8) NOT NULL, [GUARANTOR] [char](6) NOT NULL, [STUSSN] [char](9) NOT NULL, [DISBDT1] [date] NOT NULL, [GRADE] [char](2) NOT NULL, [GRADETXT] [varchar](20) NOT NULL, [SCYPGMYR] [char](1) NOT NULL, [SCYPGMYRTXT] [varchar](20) NOT NULL, [HOSPITAL] [char](3) NOT NULL, [HOSPITALTXT] [varchar](20) NOT NULL, [CURROWN] [char](8) NOT NULL, [LOANADD] [date] NULL, [RULE78] [decimal](9, 2) NOT NULL, [DAYSREMGRC] [smallint] NOT NULL, [DAYSENROL] [smallint] NOT NULL, [REPAYBEGIN] [date] NULL, [DAYSINREPAY] [smallint] NULL, [MOSINREPAY] [smallint] NULL, [PGASHO] [varchar](20) NOT NULL, [GTRSHO] [varchar](20) NOT NULL, [CURPRIN] [decimal](9, 2) NOT NULL, [CURINT] [decimal](9, 2) NOT NULL, [GOVINT] [decimal](9, 2) NOT NULL, [CUROTHR] [decimal](9, 2) NOT NULL, [AVGDAYBAL] [decimal](9, 2) NOT NULL, [PREVPRIN] [decimal](9, 2) NOT NULL, [PREVINT] [decimal](9, 2) NOT NULL, [PREVGOVINT] [decimal](9, 2) NOT NULL, [PREVOTHR] [decimal](9, 2) NOT NULL, [BFIRST] [varchar](30) NOT NULL, [BMID] [varchar](13) NOT NULL, [BLAST] [varchar](30) NOT NULL, [BSUFFIX] [char](5) NOT NULL, [BBIRTH] [date] NULL, [SFIRST] [varchar](13) NOT NULL, [SMID] [varchar](13) NOT NULL, [SLAST] [varchar](30) NOT NULL, [SSUFFIX] [char](5) NOT NULL, [BADD1] [varchar](50) NOT NULL, [BADD2] [varchar](50) NOT NULL, [BADD3] [varchar](50) NOT NULL, [BCITY] [varchar](64) NOT NULL, [BSTATE] [char](2) NOT NULL, [BZIP] [char](9) NOT NULL, [BADDIND] [char](1) NOT NULL, [BADDLSTCHG] [date] NOT NULL, [BFOREIGNCT] [varchar](50) NOT NULL, [BFOREIGNST] [varchar](50) NOT NULL, [BPHNEXT] [char](4) NOT NULL, [BPHNNUM] [char](4) NOT NULL, [BPHNEXC] [char](3) NOT NULL, [BPHNARA] [char](3) NOT NULL, [BPHNINT1] [char](3) NOT NULL, [BPHNINT2] [char](3) NOT NULL, [BPHNINT3] [char](4) NOT NULL, [BPHNINT4] [char](7) NOT NULL, [BPHNIND] [char](1) NOT NULL, [SKIPBEG] [date] NULL, [COSIGN] [char](1) NOT NULL, [COMAKE] [char](1) NOT NULL, [COBORR] [char](1) NOT NULL, [ENDORS] [char](1) NOT NULL, [ORGSCLNM] [varchar](100) NOT NULL, [ORGSCLTP] [char](2) NOT NULL, [ORGSCLTPTXT] [varchar](50) NOT NULL, [ORGSCLPROP] [char](1) NOT NULL, [CURSCL] [char](8) NOT NULL, [LASTENROLL] [date] NULL, [DAYSGRC] [smallint] NOT NULL, [DAYSREMENR] [smallint] NOT NULL, [CURSCLTYP] [char](2) NOT NULL, [CURSCLTYPTXT] [varchar](20) NOT NULL, [CURSCLPROP] [char](1) NOT NULL, [GUARSCLCDE] [char](8) NOT NULL, [CURSCLST] [char](2) NOT NULL, [ORGSCLST] [char](2) NOT NULL, [FIRSTPAYDUE] [date] NULL, [DISCDATE] [date] NULL, [NXTINSTDUE] [date] NULL, [INTCAPFREQ] [tinyint] NOT NULL, [INTCAPFREQTXT] [varchar](15) NOT NULL, [REPTYPE] [char](2) NOT NULL, [REPTYPETXT] [varchar](50) NOT NULL, [INSTLAMT1] [decimal](9, 2) NOT NULL, [INSTLAMT2] [decimal](9, 2) NOT NULL, [INSTLAMT3] [decimal](9, 2) NOT NULL, [INSTLAMT4] [decimal](9, 2) NOT NULL, [INSTLAMT5] [decimal](9, 2) NOT NULL, [INSTLAMT6] [decimal](9, 2) NOT NULL, [INSTLAMT7] [decimal](9, 2) NOT NULL, [REPTERM1] [smallint] NOT NULL, [REPTERM2] [smallint] NOT NULL, [REPTERM3] [smallint] NOT NULL, [REPTERM4] [smallint] NOT NULL, [REPTERM5] [smallint] NOT NULL, [REPTERM6] [smallint] NOT NULL, [REPTERM7] [smallint] NOT NULL, [INIREPTERM] [smallint] NOT NULL, [DISB1AMT] [decimal](9, 2) NOT NULL, [TOTDISB] [decimal](9, 2) NOT NULL, [TOTINS] [decimal](9, 2) NOT NULL, [TOTORGFEE] [decimal](9, 2) NULL, [TOTOTHRFEE] [decimal](9, 2) NULL, [ORIGPRIN] [decimal](9, 2) NOT NULL, [FULLDISB] [char](1) NOT NULL, [LASTDISBDATE] [date] NULL, [LASTDISBAMT] [decimal](9, 2) NOT NULL, [DEFBEG] [date] NULL, [DEFEND] [date] NULL, [DAYREMDFR] [smallint] NOT NULL, [DEFERTYP] [char](2) NOT NULL, [DEFERTXT] [varchar](20) NOT NULL, [MOSELAPDFR] [smallint] NOT NULL, [CURFORBBEG] [date] NULL, [CURFORBEND] [date] NULL, [DAYFORBREM] [smallint] NOT NULL, [FORBTYP] [char](2) NOT NULL, [FORBTXT] [varchar](20) NOT NULL, [MOSELAPFOR] [smallint] NOT NULL, [INIFORBAPP] [char](1) NOT NULL, [NUMSUBSFORB] [tinyint] NOT NULL, [PRECLAIMSUB] [date] NULL, [INICLAIMSUB] [date] NULL, [CLAIMREAS] [char](2) NOT NULL, [CLAIMREASTXT] [varchar](20) NOT NULL, [CLAIMREJDATE] [date] NULL, [CLAIMPD] [date] NULL, [CLMINTPD] [decimal](9, 2) NOT NULL, [CLMPRIPD] [decimal](9, 2) NOT NULL, [DAYSAGE] [smallint] NOT NULL, [INICLMRESUB] [date] NULL, [SUPCLMRESUB] [date] NULL, [SUPCLMPD] [date] NULL, [SUPPINTPD] [decimal](9, 2) NOT NULL, [SUPPRINPD] [decimal](9, 2) NOT NULL, [BORRINTPUR] [decimal](9, 2) NOT NULL, [BORRPRIPUR] [decimal](9, 2) NOT NULL, [DAYSREPCONV] [smallint] NOT NULL, [DAYCAPAPPL] [date] NULL, [AMTLASTCAP] [decimal](9, 2) NOT NULL, [TOTCAPINT] [decimal](9, 2) NOT NULL, [NUMDAYINTCAP] [smallint] NOT NULL, [INTWRIOFF] [decimal](9, 2) NOT NULL, [PRIWRIOFF] [decimal](9, 2) NOT NULL, [LASTPMT] [date] NULL, [LASTPRIPMT] [decimal](9, 2) NOT NULL, [LASTINTPMT] [decimal](9, 2) NOT NULL, [ZEROBALCD] [char](2) NOT NULL, [ZEROBALTXT] [varchar](20) NOT NULL, [ZEROBALSUBCD] [char](2) NOT NULL, [ZEROBALSUBTXT] [varchar](20) NOT NULL, [ZEROBALAPL] [date] NULL, [ZEROBALEFF] [date] NULL, [DELQDAYS] [smallint] NOT NULL, [DELIQDATE] [date] NULL, [DAYSINTDELQ] [smallint] NOT NULL, [INTDELQDATE] [date] NULL, [CYCLESTAT] [char](2) NOT NULL, [CYCLETEXT] [varchar](20) NOT NULL, [CYCLESUB] [char](2) NOT NULL, [SUBCYCTEXT] [varchar](20) NOT NULL, [REMREPAYTERM] [smallint] NOT NULL, [CURINSTAMT] [decimal](9, 2) NOT NULL, [EXPPAYOFF] [date] NULL, [DAYSREMREP] [smallint] NULL, [OWNSHO] [varchar](20) NOT NULL, [OWNERPARENT] [char](8) NOT NULL, [SUPEROWNER] [varchar](20) NOT NULL, [OWNERBOND] [char](8) NOT NULL, [SECONPORT] [varchar](20) NOT NULL, [OWNERSTART] [date] NOT NULL, [TAXABLEBOND] [char](1) NOT NULL, [SOLDDATE] [date] NULL, [SELLER] [char](8) NOT NULL, [OWNERST] [char](2) NOT NULL, [INTTYPE1] [char](2) NOT NULL, [INTTYPE2] [char](2) NOT NULL, [INTTYPE3] [char](2) NOT NULL, [INTTYPE4] [char](2) NOT NULL, [INTTEXT1] [varchar](20) NOT NULL, [INTTEXT2] [varchar](20) NOT NULL, [INTTEXT3] [varchar](20) NOT NULL, [INTTEXT4] [varchar](20) NOT NULL, [INTBEGDATE1] [date] NOT NULL, [INTBEGDATE2] [date] NULL, [INTBEGDATE3] [date] NULL, [INTBEGDATE4] [date] NULL, [INTENDDATE1] [date] NULL, [INTENDDATE2] [date] NULL, [INTENDDATE3] [date] NULL, [INTENDDATE4] [date] NULL, [INTAPPDATE1] [date] NOT NULL, [INTAPPDATE2] [date] NULL, [INTAPPDATE3] [date] NULL, [INTAPPDATE4] [date] NULL, [INTRATETYP1] [decimal](5, 3) NOT NULL, [INTRATETYP2] [decimal](5, 3) NOT NULL, [INTRATETYP3] [decimal](5, 3) NOT NULL, [INTRATETYP4] [decimal](5, 3) NOT NULL, [SPECINTCOD1] [char](1) NOT NULL, [SPECINTCOD2] [char](1) NOT NULL, [SPECINTCOD3] [char](1) NOT NULL, [SPECINTCOD4] [char](1) NOT NULL, [SUBINTTYPE1] [char](1) NOT NULL, [SUBINTTYPE2] [char](1) NOT NULL, [SUBINTTYPE3] [char](1) NOT NULL, [SUBINTTYPE4] [char](1) NOT NULL, [SUNINTTEXT1] [varchar](20) NOT NULL, [SUNINTTEXT2] [varchar](20) NOT NULL, [SUNINTTEXT3] [varchar](20) NOT NULL, [SUNINTTEXT4] [varchar](20) NOT NULL, [PAYRPD] [int] NOT NULL, [FNLDMDBR] [date] NULL, [FNLDMDCOS] [date] NULL, [PORTAGELN1] [char](3) NOT NULL, [PORTAGELN2] [char](3) NOT NULL, [PORTRPTLN1] [char](3) NOT NULL, [PORTRPTLN2] [char](4) NOT NULL, [PORTRPTLN3] [char](2) NOT NULL, [PORTRPTLN4] [char](3) NOT NULL, [PORTRPTLN5] [char](3) NOT NULL, [PORTTIMLIN] [char](3) NOT NULL, [CREATEDATE] [date] NOT NULL, [LITSTATCOD] [char](2) NOT NULL, [DATELITBEG] [date] NULL, [NEWLOANIND] [char](1) NOT NULL, [LON1OWNRPT] [char](1) NOT NULL, [TIERPRICE] [char](3) NOT NULL, [AMTGUARANT] [decimal](9, 2) NOT NULL, [DATEGUARAN] [date] NULL, [MOSREMGRAC] [smallint] NOT NULL, [MOSREMDEFR] [smallint] NOT NULL, [MOSREMFORB] [smallint] NOT NULL, [MOSREMENRO] [smallint] NOT NULL, [MOSREMREPA] [smallint] NOT NULL, [MOSZEROBAL] [smallint] NOT NULL, [MOSINGRACE] [smallint] NOT NULL, [MOSENROLLD] [smallint] NOT NULL, [MOSINLITIG] [smallint] NOT NULL, [SOLDCODE] [char](1) NOT NULL, [SOLDTEXT] [varchar](20) NOT NULL, [BSTAPPCODE] [char](2) NOT NULL, [PRINXFRSAL] [decimal](9, 2) NULL, [INTXFRSALE] [decimal](9, 2) NULL, [LONSUBSTAT] [char](2) NULL, [NEWZEROBAL] [char](2) NOT NULL, [NEWZEROTXT] [varchar](20) NOT NULL, [NEWZEROSUB] [char](2) NOT NULL, [NEWZEROSUBTXT] [varchar](20) NOT NULL, [NEWZEROAPPDATE] [date] NULL, [NEWZEROEFFDATE] [date] NULL, [EMAILADDCD] [char](1) NOT NULL, [EMAILADDVF] [date] NULL, [EMAILVALID] [char](1) NULL, [EMAILADDLN] [tinyint] NULL, [EMAILADDTX] [varchar](255) NULL, [MSTRPROMCD] [char](1) NOT NULL, [MSTRPROMEX] [varchar](10) NOT NULL, [MSTRPROMTY] [char](1) NOT NULL, [MSTRPROMRE] [char](2) NOT NULL, [ORIGSEASON] [char](8) NOT NULL, [ALTLOANID] [varchar](17) NOT NULL, [COMMONSEQ] [char](4) NOT NULL, [PNOTESIGN] [date] NULL, [MNOTE] [varchar](11) NULL, [MNOTESEQ] [char](4) NULL, [REDPGMNM] [char](3) NULL, [CAPALLOW] [char](1) NULL, [LNOWNNUM] [varchar](17) NULL, [CRSCORE] [smallint] NULL, [REDPGMTXT] [varchar](20) NULL, [ORIGPORT] [varchar](20) NULL, [PNOTEYR] [char](7) NULL, [PNOTEYRTXT] [varchar](20) NULL, [BORACCID] [char](10) NULL, [STTUACCID] [char](10) NULL, [SERVICERCD] [tinyint] NOT NULL, [SERVICERTXT] [varchar](20) NOT NULL, [FMCTRUST] [bit] NOT NULL, [DATAFILENAME] [varchar](255) NULL, [LOADDATE] [smalldatetime] NOT NULL, [cm_loan_key] [int] NOT NULL, [cm_rule_id] [smallint] NOT NULL, [totmosindefer] [tinyint] NULL, [totmosinforb] [tinyint] NULL, [cm_guarantor] [char](6) NOT NULL, [CSSN] [char](9) NULL, [CACCID] [char](10) NULL, [CFIRST] [varchar](30) NULL, [CMID] [varchar](13) NULL, [CLAST] [varchar](30) NULL, [CSUFFIX] [char](5) NULL, [CBIRTH] [date] NULL, [CADD1] [varchar](50) NULL, [CADD2] [varchar](50) NULL, [CADD3] [varchar](50) NULL, [CCITY] [varchar](64) NULL, [CSTATE] [char](2) NULL, [CZIP] [char](9) NULL, [CADDIND] [char](1) NULL, [CADDLDT] [date] NULL, [CADDFLG] [char](1) NULL, [CPHNARA] [char](3) NULL, [CPHNEXC] [char](3) NULL, [CPHNNUM] [char](4) NULL, [CPHNEXT] [char](5) NULL, [CPHNIND] [char](1) NULL, [CEMAILADDTX] [varchar](255) NULL, [CEMAILADDCD] [char](1) NULL, [C2SSN] [char](9) NULL, [C2ACCID] [char](10) NULL, [C2FIRST] [varchar](13) NULL, [C2MID] [varchar](13) NULL, [C2LAST] [varchar](23) NULL, [C2SUFFIX] [char](5) NULL, [C2BIRTH] [date] NULL, [C2ADD1] [varchar](50) NULL, [C2ADD2] [varchar](50) NULL, [C2ADD3] [varchar](50) NULL, [C2CITY] [varchar](64) NULL, [C2STATE] [char](2) NULL, [C2ZIP] [char](9) NULL, [C2ADDIND] [char](1) NULL, [C2ADDLDT] [date] NULL, [C2ADDFLG] [char](1) NULL, [C2PHNARA] [char](3) NULL, [C2PHNEXC] [char](3) NULL, [C2PHNNUM] [char](4) NULL, [C2PHNEXT] [char](5) NULL, [C2PHNIND] [char](1) NULL, [C2EMAILADDTX] [varchar](255) NULL, [C2EMAILADDCD] [char](1) NULL, [C3SSN] [char](9) NULL, [C3ACCID] [char](10) NULL, [C3FIRST] [varchar](13) NULL, [C3MID] [varchar](13) NULL, [C3LAST] [varchar](23) NULL, [C3SUFFIX] [char](5) NULL, [C3BIRTH] [date] NULL, [C3ADD1] [varchar](50) NULL, [C3ADD2] [varchar](50) NULL, [C3ADD3] [varchar](50) NULL, [C3CITY] [varchar](64) NULL, [C3STATE] [char](2) NULL, [C3ZIP] [char](9) NULL, [C3ADDIND] [char](1) NULL, [C3ADDLDT] [date] NULL, [C3ADDFLG] [char](1) NULL, [C3PHNARA] [char](3) NULL, [C3PHNEXC] [char](3) NULL, [C3PHNNUM] [char](4) NULL, [C3PHNEXT] [char](5) NULL, [C3PHNIND] [char](1) NULL, [C3EMAILADDTX] [varchar](255) NULL, [C3EMAILADDCD] [char](1) NULL, [DATAFILENAME_SUP] [varchar](255) NULL, [CSEPARCD] [char](2) NULL, [CREAS] [varchar](40) NULL, [CREASCD] [char](2) NULL, [CSCDESC] [varchar](40) NULL, [CLEARHFLG] [char](1) NULL, [SKIPBEGDT] [date] NULL, [SGMNTCD] [char](2) NULL, [RISKSCORE] [tinyint] NULL, [SGMNTSTRTGY] [char](3) NULL, [BILLAMT] [decimal](9, 2) NULL, [BILLDUEDT] [date] NULL, [IMCD] [varchar](17) NULL, [PASTDUEAMT] [decimal](9, 2) NULL, [NUMPAYPASTDUE] [tinyint] NULL, [NUMPAYSMO] [tinyint] NULL, [MAXDELQ] [smallint] NULL, [MAXDELQDT] [date] NULL, [CMBBILLCD] [char](1) NULL, [IDXTYPCD] [char](3) NULL, [IDXTYPTXT] [varchar](40) NULL, [GFEEREPAYPCT] [decimal](6, 3) NULL, [GFEEREPAYAMT] [decimal](9, 2) NULL, [BILLSENTDT] [date] NULL, [MAXMTHFORBALLOW] [tinyint] NULL, [AUTHUSRIND] [char](1) NULL, [CALLSRECD] [tinyint] NULL, [LSTCALLRECDDT] [date] NULL, [CALLSOUT] [tinyint] NULL, [LSTCALLOUTDT] [date] NULL, [LSTLTRDT] [date] NULL, [LSTLTRCD] [char](5) NULL, [CCALLSOUT] [tinyint] NULL, [CLSTCALLOUTDT] [date] NULL, [CLSTLTRDT] [date] NULL, [CLSTLTRCD] [char](5) NULL, [DEATHNTFDT] [date] NULL, [DEATHFIRST] [varchar](13) NULL, [DEATHMID] [varchar](13) NULL, [DEATHLAST] [varchar](23) NULL, [DEATHDT] [date] NULL, [BNKRPTCYNTFDT] [date] NULL, [BNKRPTCYFILSSN] [char](9) NULL, [BNKRPTCYDT] [date] NULL, [BNKRPTCYFILCITY] [varchar](64) NULL, [BNKRPTCYFILST] [char](2) NULL, [BNKRPTCYCASENO] [varchar](12) NULL, [BNKRPTCYTYP] [char](2) NULL, [ORIGISSUEDISC] [decimal](15, 2) NULL, [LETTERID] [varchar](10) NULL, [ACTIONDEFDESC] [varchar](20) NULL, [CLETTERID] [varchar](10) NULL, [CACTIONDEFDESC] [varchar](20) NULL, [BKRSTA] [char](2) NULL, [BKRSTATXT] [varchar](20) NULL, [CADDVALID] [char](1) NULL, [CEMAILVALID] [char](1) NULL, [CPHNVALID] [char](1) NULL, [C2ADDVALID] [char](1) NULL, [C2EMAILVALID] [char](1) NULL, [C2PHNVALID] [char](1) NULL, [C3ADDVALID] [char](1) NULL, [C3EMAILVALID] [char](1) NULL, [C3PHNVALID] [char](1) NULL, [NXTINSTDUE_BILLED] [decimal](9, 2) NULL, [BILLTYPE] [char](1) NULL, [INTRATEREDPGM] [char](1) NULL, [SCRAFLAG] [char](1) NULL, [SCRABEGINDT] [date] NULL, [SCRAENDDT] [date] NULL, [COSRELRCVDDT] [date] NULL, [COSRELGRANTDT] [date] NULL, [ACHREQDT] [date] NULL, [HSP_TOTDAYSFORB_ALLOC] [smallint] NULL, [HSP_totdayinforb] [smallint] NULL, [HSP_totmosinforb] [decimal](4, 1) NULL, [HSP_MAXDAYFORBALLOW] [smallint] NULL, [HSP_MAXMTHFORBREMAIN] [decimal](4, 1) NULL, [HSP_MAXDAYFORBREMAIN] [smallint] NULL, [HSP_totmosinforb_alloc] [decimal](4, 1) NULL, [DAYELAPFOR] [smallint] NULL, [CURFORBDAYS] [smallint] NULL, [CURFORBMTHS] [tinyint] NULL, CONSTRAINT [PK_Test] PRIMARY KEY CLUSTERED ( [WHSE_ID] ASC, [CREATEDATE] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], CONSTRAINT [UQ_Test_CREATEDATE_BSSN_SEQ_PROGRAM_GUARANTOR_CURROWN_OWNERBOND] UNIQUE NONCLUSTERED ( [CREATEDATE] ASC, [BSSN] ASC, [SEQ] ASC, [PROGRAM] ASC, [GUARANTOR] ASC, [CURROWN] ASC, [OWNERBOND] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 70) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_PADDING ON GO CREATE NONCLUSTERED INDEX [IX_Test_ALTLOANID_CREATEDATE] ON [dbo].[Test] ( [ALTLOANID] ASC ) ON [PRIMARY] GO CREATE NONCLUSTERED INDEX [IX_Test_AMTGUARANT_CREATEDATE] ON [dbo].[Test] ( [AMTGUARANT] ASC ) ON [PRIMARY] GO CREATE NONCLUSTERED INDEX [IX_Test_BBIRTH_CREATEDATE] ON [dbo].[Test] ( [BBIRTH] ASC ) ON [PRIMARY] GO CREATE NONCLUSTERED INDEX [IX_Test_BLAST_CREATEDATE] ON [dbo].[Test] ( [BLAST] ASC ) ON [PRIMARY] GO CREATE NONCLUSTERED INDEX [IX_Test_BORACCID_CREATEDATE] ON [dbo].[Test] ( [BORACCID] ASC ) ON [PRIMARY] GO CREATE NONCLUSTERED INDEX [IX_Test_BSSN_SEQ_CREATEDATE_cm_loan_key] ON [dbo].[Test] ( [BSSN] ASC, [SEQ] ASC, [CREATEDATE] ASC ) INCLUDE ( [cm_loan_key]) ON [PRIMARY] GO CREATE NONCLUSTERED INDEX [IX_Test_BSSN_SEQ_INICLAIMSUB_CREATEDATE] ON [dbo].[Test] ( [BSSN] ASC, [SEQ] ASC, [INICLAIMSUB] ASC, [CREATEDATE] ASC ) ON [PRIMARY] GO CREATE NONCLUSTERED INDEX [IX_Test_CLAIMREAS_CREATEDATE] ON [dbo].[Test] ( [CLAIMREAS] ASC ) ON [PRIMARY] GO CREATE NONCLUSTERED INDEX [IX_Test_CLETTERID_CREATEDATE] ON [dbo].[Test] ( [CLETTERID] ASC ) ON [PRIMARY] GO CREATE NONCLUSTERED INDEX [IX_Test_cm_guarantor_CREATEDATE] ON [dbo].[Test] ( [cm_guarantor] ASC ) ON [PRIMARY] GO CREATE NONCLUSTERED INDEX [IX_Test_cm_loan_key_CREATEDATE] ON [dbo].[Test] ( [cm_loan_key] ASC ) ON [PRIMARY] GO CREATE NONCLUSTERED INDEX [IX_Test_cm_loan_key_CURROWN_CREATEDATE] ON [dbo].[Test] ( [cm_loan_key] ASC, [CURROWN] ASC, [CREATEDATE] ASC ) ON [PRIMARY] GO CREATE NONCLUSTERED INDEX [IX_Test_COSIGN_CREATEDATE] ON [dbo].[Test] ( [COSIGN] ASC ) ON [PRIMARY] GO CREATE NONCLUSTERED INDEX [IX_Test_CREATEDATE] ON [dbo].[Test] ( [CREATEDATE] ASC ) ON [PRIMARY] GO CREATE NONCLUSTERED INDEX [IX_Test_CREATEDATE_FMCTRUST] ON [dbo].[Test] ( [CREATEDATE] ASC, [FMCTRUST] ASC ) ON [PRIMARY] GO CREATE NONCLUSTERED INDEX [IX_Test_CSSN_CREATEDATE] ON [dbo].[Test] ( [CSSN] ASC ) ON [PRIMARY] GO CREATE NONCLUSTERED INDEX [IX_Test_CURROWN_CREATEDATE] ON [dbo].[Test] ( [CURROWN] ASC ) ON [PRIMARY] GO CREATE NONCLUSTERED INDEX [IX_Test_CURSCL_CREATEDATE] ON [dbo].[Test] ( [CURSCL] ASC ) ON [PRIMARY] GO CREATE NONCLUSTERED INDEX [IX_Test_CYCLESTAT_CREATEDATE] ON [dbo].[Test] ( [CYCLESTAT] ASC ) ON [PRIMARY] GO CREATE NONCLUSTERED INDEX [IX_Test_CYCLESUB_CREATEDATE] ON [dbo].[Test] ( [CYCLESUB] ASC ) ON [PRIMARY] GO CREATE NONCLUSTERED INDEX [IX_Test_DATAFILENAME_CREATEDATE] ON [dbo].[Test] ( [DATAFILENAME] ASC ) ON [PRIMARY] GO CREATE NONCLUSTERED INDEX [IX_Test_DATEGUARAN_CREATEDATE] ON [dbo].[Test] ( [DATEGUARAN] ASC ) ON [PRIMARY] GO CREATE NONCLUSTERED INDEX [IX_Test_DEFERTYP_CREATEDATE] ON [dbo].[Test] ( [DEFERTYP] ASC ) ON [PRIMARY] GO CREATE NONCLUSTERED INDEX [IX_Test_DISB1AMT_CREATEDATE] ON [dbo].[Test] ( [DISB1AMT] ASC ) ON [PRIMARY] GO CREATE NONCLUSTERED INDEX [IX_Test_DISBDT1_CREATEDATE] ON [dbo].[Test] ( [DISBDT1] ASC ) ON [PRIMARY] GO CREATE NONCLUSTERED INDEX [IX_Test_FORBTYP_CREATEDATE] ON [dbo].[Test] ( [FORBTYP] ASC ) ON [PRIMARY] GO CREATE NONCLUSTERED INDEX [IX_Test_FULLDISB_CREATEDATE] ON [dbo].[Test] ( [FULLDISB] ASC ) ON [PRIMARY] GO CREATE NONCLUSTERED INDEX [IX_Test_GUARREF_CREATEDATE] ON [dbo].[Test] ( [GUARREF] ASC ) ON [PRIMARY] GO CREATE NONCLUSTERED INDEX [IX_Test_INICLAIMSUB_CREATEDATE] ON [dbo].[Test] ( [INICLAIMSUB] ASC ) ON [PRIMARY] GO CREATE NONCLUSTERED INDEX [IX_Test_LENDER_PROGRAM_CREATEDATE] ON [dbo].[Test] ( [LENDER] ASC, [PROGRAM] ASC ) ON [PRIMARY] GO CREATE NONCLUSTERED INDEX [IX_Test_LETTERID_CREATEDATE] ON [dbo].[Test] ( [LETTERID] ASC ) ON [PRIMARY] GO CREATE NONCLUSTERED INDEX [IX_Test_LNOWNNUM_CREATEDATE] ON [dbo].[Test] ( [LNOWNNUM] ASC ) ON [PRIMARY] GO CREATE NONCLUSTERED INDEX [IX_Test_LOANADD_CREATEDATE] ON [dbo].[Test] ( [LOANADD] ASC ) ON [PRIMARY] GO CREATE NONCLUSTERED INDEX [IX_Test_NEWZEROBAL_CREATEDATE] ON [dbo].[Test] ( [NEWZEROBAL] ASC ) ON [PRIMARY] GO CREATE NONCLUSTERED INDEX [IX_Test_NEWZEROBAL_OWNERBOND_CREATEDATE] ON [dbo].[Test] ( [NEWZEROBAL] ASC, [OWNERBOND] ASC ) ON [PRIMARY] GO CREATE NONCLUSTERED INDEX [IX_Test_NEWZEROSUB_CREATEDATE] ON [dbo].[Test] ( [NEWZEROSUB] ASC ) ON [PRIMARY] GO CREATE NONCLUSTERED INDEX [IX_Test_ORGSCLNM_CREATEDATE] ON [dbo].[Test] ( [ORGSCLNM] ASC ) ON [PRIMARY] GO CREATE NONCLUSTERED INDEX [IX_Test_ORIGSCL_CREATEDATE] ON [dbo].[Test] ( [ORIGSCL] ASC ) ON [PRIMARY] GO CREATE NONCLUSTERED INDEX [IX_Test_ORIGSEASON_CREATEDATE] ON [dbo].[Test] ( [ORIGSEASON] ASC ) ON [PRIMARY] GO CREATE NONCLUSTERED INDEX [IX_Test_OWNERBOND_CREATEDATE] ON [dbo].[Test] ( [OWNERBOND] ASC, [CREATEDATE] ASC ) ON [PRIMARY] GO CREATE NONCLUSTERED INDEX [IX_Test_PNOTEYR_CREATEDATE] ON [dbo].[Test] ( [PNOTEYR] ASC ) ON [PRIMARY] GO CREATE NONCLUSTERED INDEX [IX_Test_PROGRAM_CREATEDATE] ON [dbo].[Test] ( [PROGRAM] ASC ) ON [PRIMARY] GO CREATE NONCLUSTERED INDEX [IX_Test_TIERPRICE_CREATEDATE] ON [dbo].[Test] ( [TIERPRICE] ASC ) ON [PRIMARY] GO CREATE NONCLUSTERED INDEX [IX_Test_ZEROBALCD_CREATEDATE] ON [dbo].[Test] ( [ZEROBALCD] ASC ) ON [PRIMARY] GO CREATE NONCLUSTERED INDEX [IX_Test_ZEROBALSUBCD_CREATEDATE] ON [dbo].[Test] ( [ZEROBALSUBCD] ASC ) ON [PRIMARY] GO ALTER TABLE [dbo].[Test] WITH CHECK ADD CONSTRAINT [CK_Test_CREATEDATE] CHECK (([CREATEDATE]>='19961201' AND [CREATEDATE]<'20161001')) GO ALTER TABLE [dbo].[Test] CHECK CONSTRAINT [CK_Test_CREATEDATE] GO ALTER TABLE [dbo].[Test] WITH CHECK ADD CONSTRAINT [CK_Test_SERVICERCD] CHECK (([SERVICERCD]=(1))) GO ALTER TABLE [dbo].[Test] CHECK CONSTRAINT [CK_Test_SERVICERCD] GO ALTER TABLE [dbo].[Test] ADD CONSTRAINT [DF_Test_LOADDATE] DEFAULT (getdate()) FOR [LOADDATE] GO ALTER TABLE [dbo].[Test] ADD CONSTRAINT [DF_Test_totmosindefer] DEFAULT ((0)) FOR [totmosindefer] GO ALTER TABLE [dbo].[Test] ADD CONSTRAINT [DF_Test_totmosinforb] DEFAULT ((0)) FOR [totmosinforb] GO
Comments
Thank you for your forum post and sorry that you have encountered a problem.
What exact full version number of SQL Data Compare are you using?
Would you please enable the verbose logging, as per this help ARTICLE and repeat the steps you took previously? When the problem occurs, locate the current log file and send a copy to support@red-gate.com with the subject "Support Ticket #76008.
Many Thanks
Eddie
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com
Well, you could always retain the # objects in the project file after the first run. As long as there are only minor changes to the # objects you'd be fine, and in case of large # of changes, you'd still have the 100% cap in place.