Somebody please rescue me from the hours and hours that I am spending trying to find the answers to some questions about Extended Stored Procedures and the SQL Error Logs!!
1) The extended stored procedure C/C++ API function srv_sendmsg is able to produce error messages that show up in red, etc. when executed from Query Analyzer, just like raiserror. The raiserror statement has an optional with log qualifier that will cause it to write the SQL Error Logs. Is there a way to make srv_sendmsg write to the SQL Error Logs?
2) When an extended stored procedure is executed as part of an insert into … exec statement, all src_sendmsg output is lost. And, since I can’t make it write to the SQL Error Logs, it’s really lost. (For the record, insert into … exec with a regular stored procedure containing a raiserror statement works fine.)
Thanks in Advance,
MultiMedia