0

I have several SQL Servers and databases and when I compile a Stored Procedure I receive one of two responses...

ALTER_PROCEDURE - dbo.usp_MyProcedure

or

Command(s) completed successfully.

My question is why did I receive different responses. The setting has to be at the server level somewhere, because every database on that server where I compile the SP I get the same message. I received the alter message on 17 databases on 3 servers, and the command completed message on 19 databases on 7 servers.

I use Redgate's Multi Script to push the stored procedure at the same time, I know it is not in Multi Script due to compiling the SP using SSMS yields the sames responses. Can anybody point me to the setting that controls this response?

  • @sp_BlitzErik As I stated in my post, "I know it is not in Multi Script due to compiling the SP using SSMS yields the sames responses." – Semperfi89 Feb 19 '18 at 17:05
  • It looks like a DDL trigger that echos the DDL operations. It seems it's not installed on the other database. – Dan Guzman Feb 19 '18 at 17:06
  • @DanGuzman You are correct, I found a trigger from an old Source control that was doing this. If you post your comment as an answer I'll select it. – Semperfi89 Feb 19 '18 at 17:40
1

It looks like a DDL trigger exists in some, but not all, of the databases. The trigger apparently uses a PRINT or RAISERROR statement to generate a message containing the DDL action and object name.

|improve this answer|||||

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.