I would like to be able to return more than 2 fields from a custom stored procedure. There are situations where information being returned, can be very helpful in issue resolution. One example that may already be out there and solved, but for the sake of the discussion is blocked processes / dead locks. I can write a stored procedure, or table return (fx) that will return full blocking chains. say there were 10 blocks, knowing there were 10 blocks is great. Having the information of all the SPIDs, and other information that can be ascertained through DMVs could return the entire chain. This will allow much faster resolution when the "Blocked process alert" is fired off. That is just one trivial example, leveraging a return value that is a data-set which MUST include the 2 out parameters DPA needs last would extend the custom Alert feature by miles.
Thanks,
Dr. John T
