I wish I could do that but because of the third party software architecture, I have to make the call in the From clause.  Looks like the only issue is...

If there is another way to put a stored procedure call in a From clause, I'd love to know.  Having this call in a From clause would be useful in...

The temp table, in this case, would be used inside the stored procedure to consolidate all the record sets, then pass back one record set that would be feed into...

The overall goal is to use the stored procedure in a SQL statement, for example:

SELECT * FROM OPENQUERY(SERVER, 'EXEC SP_CALL')

The while loop grabs each record of a table.  Each record...

The DBCC CHECKDB is not happening every night, nor at the same time of day but the times that the table lock occurred, yes, the DBCC CHECKDB ran around those...

Error 50001 falls outside the reserved system errors, it is user defined and nothing else should be calling it.  The Microsoft documentation suggests using RAISERROR inside triggers instead of the xp_logevent:

"When...

I'm not sure I know what you mean.  The count happens when I use the RAISERROR function in the trigger.

Here is some other info in the alert:

Type - SQL Server...

CREATE TRIGGER TRG_GOAL ON DBO.GOAL

FOR INSERT, UPDATE, DELETE

AS

INSERT INTO IPGOALS.DBO.PROCESS_CONTROL_GOAL(TRIGGER_LOAD) VALUES (GETDATE())

RAISERROR(50001,10,1)