It would be very useful if the results of a stored procedure could automatically refresh themselves as a process completes on the database.
Two of many use cases are:
- You are monitoring an external process and monitoring a log table.
- You are monitoring one or more processes that are using the SQL Server Service Broker to execute Asyncronously.