This will probably be an odd question, but do any of you know how to
view the query a program generates?

Here's my problem. I have a program that generates a temporary table
that is used during the creation of a report and then deleted. I want
to create either a view or a table that mirrors that temp table so I can
build my own reports. I've got a request in to the company, but so far
no response. I'm wondering if it's possible to view or capture the
query and/or sql statement via some program or method.

It's a SQL Server 2000 backend.
Matthew - The Great System Tyrant