Search
-
SQL Compare scripts INCORRECT error handling??
PRINT N'Altering [dbo].[linerLogMessageType]'GOALTER TABLE [dbo].[linerLogMessageType] ALTER COLUMN [name] [nvarchar] (160) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULLALTER TABLE [dbo].[linerLogMessageType] ALTER COLUMN [dateTimeStamp] [datetime] NOT NULLALTER TABLE [dbo].[linerLogMessageType] ALTER COLUMN [hostname]… -
Re: SQL Compare scripts INCORRECT error handling??
Hi, Peter Sorry for the long delay in reply as my browser was pulling from a cache or something and I didn't realize there was a reply for me. Anyway, My point was that if the first two statements error-ed and the third one was successful, @@ERROR would be equal to 0 and you wouldn't catch that there was an error. Since… -
Re: SQL Compare scripts INCORRECT error handling??
Hi there, The entire script that SQL Compare generates (unless you specify otherwise in the options) is wrapped in a single transaction. With this in mind, if you have a failure then the entier script will be rolled back. In this particular scenario, neither of the first 2 ALTER TABLE statements have been committed, and…
3 results