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
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?