Monitor and change SQL queries with SQL Server 2000

Question

I have a database upgrade tool that is misbehaving. I would like to catch one of the queries it sends to the database and change it before it is executed.

The tool connects via ODBC.

The tool and the SQL Server are on the same Windows 2003 Server box.

Any ideas?

EDIT: (More info) When the tool runs it dies on step 12 out of 100. It issues some bad SQL intended to create a view. I need to suppress the error message or correct the SQL before it is executed. I can't just create the view because the first thing it does it drop the view. Even then it would error because the view would already exist.

Answer 1

Certainly - use the SQL Profiler to intercept and record the query.

Very useful little tool that...