Warning: Ignored statement found in file : while running sqlcompare
RajeshDN008
Posts: 1 New member
HI Team,
I am getting the warning "Warning: Ignored statement found in file " while running sqlcompare. I am using sqlcompare 10.
i know its just a warning.. but when i use sql data compare after this, i dont see the actual data difference as the warning caused the insertion statements to be ignored.
file content looks like below.
SET IDENTITY_INSERT [dbo].[ABC] ON
INSERT [dbo].[ABC] ([ABCId], [ABCName]) VALUES (1, '1')
SET IDENTITY_INSERT [dbo].[ABC] OFF
I am getting the warning "Warning: Ignored statement found in file " while running sqlcompare. I am using sqlcompare 10.
i know its just a warning.. but when i use sql data compare after this, i dont see the actual data difference as the warning caused the insertion statements to be ignored.
file content looks like below.
SET IDENTITY_INSERT [dbo].[ABC] ON
INSERT [dbo].[ABC] ([ABCId], [ABCName]) VALUES (1, '1')
SET IDENTITY_INSERT [dbo].[ABC] OFF
