Can I use profiler to watch a table from an application?

I need to create an application which watches for changes to one or two
tables in a SQL Server database.

I originally considered adding a trigger to the table which would add a row
to another table recording some information about the change. This second
table would then be scanned by the application (it would delete rows it had
processed - in fact it would be a queue).

However I was wondering if I could instead create a trace which the
application could monitor in real time. It seems that traces can be created
which are written to a file, but you have to stop the trace to look at the
file.

Any suggestions?


.

Relevant Pages