"EXEC : warning : Ignored statement found in file" warnings
JackAce
Posts: 75 New member
SQL Source Control is adding "USE [DATABASE_NAME]" statements to a handful of our Stored Procedures and I'm not sure why. When we deploy database changes, we see the warning
We also see the warning
Why is SQL Source Control adding these statements? Is there a way to remove the statements? Is there a way to get SQL Compare to suppress the warnings?
I'm using SQL Source Control v3.7.5.328 and SQL Compare v11.1.0.1.
EXEC : warning : Ignored statement found in file XXXXX.sql at line 1in our build output.
We also see the warning
EXEC : warning : If statement in file XXXXX.sql at line 5 considered as truethat is a result of an autogenerated
IF EXISTS (SELECT * FROM sys.sysobjects WHERE name = 'XXXXX AND xtype = 'P')statement.
Why is SQL Source Control adding these statements? Is there a way to remove the statements? Is there a way to get SQL Compare to suppress the warnings?
I'm using SQL Source Control v3.7.5.328 and SQL Compare v11.1.0.1.
Comments
Our apologies for the late reply through this forum.
We've opened up a support ticket for you to further explore this issue. Please let us know if you have further questions or concerns in the meantime.
Best,
David