Search code examples
sql-serversql-server-2005sql-server-2008sql-server-profiler

How to filter SQL Server 2008 Profiler Output for a single database?


SQL Server 2008 Profiler always profiles all databases. I want to restrict profiling or output to a single database. How can that be done most easily?


Solution

  • There is a column output/filter by database name or Id. You have to choose "Show all columns" when setting the trace up.