"EXEC : warning : Ignored statement found in file" warnings

JackAce

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

EXEC : warning : Ignored statement found in file XXXXX.sql at line 1

in our build output.

We also see the warning

EXEC : warning : If statement in file XXXXX.sql  at line 5 considered as true

that 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.

david.you

Hello,

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

JackAce

Thanks, we're still seeing this behavior.