Can I capture data from a temp table (MS SQL)
Posted on 2014-09-04
We have a .Net application but are not privy to the source code. This application makes use of a temporary table in an MS SQL database (2008, R2 soon to be upgraded). The application drops the table upon completion of the routine.
Is there any way to capture the data from this table during its short life. Since we cannot get to the source code, we cannot be in the same SQL session. I suspect the answer is no, but want to leave no stone unturned.