Finding a query submitted by software

I have a retail software that has a reporting function for its sales. It has
a SQL Server 2000 database. The table links are extremely hard to define, and
I want to be able to write custom reports. If I can see the query that it
submits I can figure out how to make my own reports for it. Is there a way in
SQL Server to locate or capture a query that is submitted by a third party
software package?
--
Scott Ford
Information Services
Starlite EntertainmentScott Ford wrote:
> I have a retail software that has a reporting function for its sales. It has
> a SQL Server 2000 database. The table links are extremely hard to define, and
> I want to be able to write custom reports. If I can see the query that it
> submits I can figure out how to make my own reports for it. Is there a way in
> SQL Server to locate or capture a query that is submitted by a third party
> software package?
I'd use SQL Profiler - it captures all queries.
Start profiler with recording the profiler data into a table. Use the
software then stop the profiler. Then analyze the profiler log.|||Thanks Yuras .. I had just discovered the Profiler minutes before your post,
but it helps to have verification that this is the tool I need.
--
Scott Ford
Information Services
Starlite Entertainment
"Yuras" wrote:
> Scott Ford wrote:
> > I have a retail software that has a reporting function for its sales. It has
> > a SQL Server 2000 database. The table links are extremely hard to define, and
> > I want to be able to write custom reports. If I can see the query that it
> > submits I can figure out how to make my own reports for it. Is there a way in
> > SQL Server to locate or capture a query that is submitted by a third party
> > software package?
> I'd use SQL Profiler - it captures all queries.
> Start profiler with recording the profiler data into a table. Use the
> software then stop the profiler. Then analyze the profiler log.
>