I've been dealing with a vendor's unconfigurable application which is, unfortunately, the most feature-complete in its niche. I'm looking to augment its capabilities with on-top screen display. Its data access is extremely predictable allows me to infer reliably from query patterns what I need to know to provide a user with additional relevant information pertaining to their current view within the application. Specifically, it always executes TSQL statement (which is the easily identifiable part) with a named parameter (which is the part that defines what the user is viewing) that I'd very much like to get at.
So, in short, I'm looking to create a mechanism that: - Hook the query pattern (trivially expressible via wildcards) - Extract the named parameter value - Sends a message to the (remote) overlay application with the parameter value
Does SQL server have any facilities for any portion of this undertaking? Is there a better way I should be going about this? (Possibly lower down in the network stack.)
Edit: We're using SQL Server 2005, but upgrading to SQL Server 2008/2008R2 isn't out of the question.