Recent Queries in SQL Server 2005
SQL Server Profiler was designed to do this.

With it you can:


capture queries as they are executed on the target instance
capture other instance and database events like deadlocks, logins, and errors
filter captured queries by text in the query, login name, database name, and so forth