SQL Server Profiler - how do I find which database is being connected? SQL Server Profiler - how do I find which database is being connected? database database

SQL Server Profiler - how do I find which database is being connected?


When you create a new trace with SQL Server Profiler, a dialog is displayed titled "Trace Properties".

In the lower-right-hand corner you should see a checkbox labeled "Show all columns. Check it. Now scroll the table to the left and you should see a checkbox labeled "Database Name". Check that, and start the trace!

TraceProperties dialog


From Trace properties -> Events Selection tab, you can show the Database Column. By default it is not shown.