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

sql-server sql-server-2005 sql-server-2008 sql-server-profiler
usr picture usr · Jul 3, 2009 · Viewed 27.2k times · Source

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?

Answer

gbn picture gbn · Jul 3, 2009

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

Related questions

How to avoid the "divide by zero" error in SQL?

I have this error message: Msg 8134, Level 16, State 1, Line 1 Divide by zero error encountered. What is the best way to write SQL code so that I will never see this error message again? I could do either of the following: …

Read More
SQL Server query to find all permissions/access for all users in a database

I would like to write a query on a sql 2008 that will report all the users that have access to a specific database, or objects within the database such as tables, views, and stored procedures, either directly or due to …

Read More
sql query to return differences between two tables

I am trying to compare two tables, SQL Server, to verify some data. I want to return all the rows from both tables where data is either in one or the other. In essence, I want to show all the …

Read More