Search
-
Re: Use of transactions in the generated script
Comment by Brian Donahue · · Home› Discontinued and Previous Versions› SQL Compare Previous VersionsHi Randy, That seems to be the case. Each object modification is rolled up in its' own nested transaction: IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION ENDGOPRINT N'Creating [dbo].[SystemSW]'GOCREATE TABLE [dbo].[SystemSW]([System] [int] NOT NULL,[SW] [int] NOT NULL)GOIF @@ERROR<>0 AND… -
Use of transactions in the generated script
Discussion by Randy Minder · · Home› Discontinued and Previous Versions› SQL Compare Previous VersionsIt's my understanding that when the script SQL Compare produces is executed, if any error is generated, all changes up to that point are rolled back and execution of the script stops. Is this correct? The reason I ask is because of the following script fragment shown below. It looks to me like if the Alter Table step…
2 results