How can we help you today? How can we help you today?

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

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.
JackAce
0

Comments

2 comments

Sort by
  • 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
    david.you
    0
  • JackAce
    Thanks, we're still seeing this behavior.
    JackAce
    0

Add comment

Please sign in to leave a comment.