Monitor and change SQL queries with SQL Server 2000

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 be开发者_开发知识库fore 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.

---

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

Very useful little tool that...