What are the challenges you face when working across database platforms? Take the survey
Options

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

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

Comments

Sign In or Register to comment.