SSMS output strangeness

• John D

  Right there with Babe

  Points: 787

  More actions

  June 23, 2011 at 1:21 pm

  #238481

  Sometimes in SSMS when I execute the below command I get the DDL command output in the result window. Any ideas what is causing this?

  IF EXISTS (SELECT 1 FROM sys.views where name = 'XXX')

  BEGIN

  PRINT N'Dropping View XXX';

  DROP VIEW XXX;

  END

  The above DROP VIEW XXX is output in the result tab in SSMS. I have also seen this output when the command is executed in SQLCMD as a script.

  Thanks for the help.

• John D

  Right there with Babe

  Points: 787

  More actions

  June 23, 2011 at 2:32 pm

  #1343392

  Forget it. We found it. It was a Database trigger with a select the text of the command.

  Thanks to all who looked at my question & thought about what might be causing it.