sql server 2008: how do you set up a trace on a specific database?

Question

i am trying to use sql server profiler to trace all the sql statements on a specific database, is this possible to do?

Answer 1

If you are talking about SQL Profiler on a 2005 or 2008 server, you can do it by adding a column filter. You will need to show all columns in the Events Selection tab. Once you do that you should see an option for Database Name.

Answer 2

Answer here