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

database sql-server-2008-r2 connection trace sql-server-profiler
Chris Halcrow picture Chris Halcrow · Jun 10, 2013 · Viewed 9.2k times · Source

I've Googled this with no success. I'm using SQL Server Profiler for SQL Server 2008 R2, and I've ensured that for the 'Events Selection' of the trace:

  • I'm reporting all columns for Security Audit > Audit Login + Audit Logout
  • I'm reporting all columns for Sessions > ExistingConnection

I then start the trace after I've loaded an .aspx page, but just before I carry out an action that calls a certain SQL stored procedure.

I can then see at the start of my trace that under the 'EventClass' column I have 'ExistingConnection', however the 'TextData' for these events doesn't seem to identify the database I'm connecting to - it's telling me the main database settings (e.g. set ansi_padding on). I can also see that for certain events I can see the 'NTUserName', which gives me some clues. What I want to find though is which database am I connecting to. Who wants some points for telling the community? :)

Answer

STLDev picture STLDev · Jun 11, 2013

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

Related questions

How to solve SQL Server Error 1222 i.e Unlock a SQL Server table

I am working in a database where I load data in a raw table by a data loader. But today the data loader got stuck for unknown reasons. Then I stopped the data loader from windows task manager. But then …

Read More
What is the syntax meaning of RAISERROR()

I just created a Instead After Trigger whose syntax is given below: Create trigger tgrInsteadTrigger on copytableto Instead of Insert as Declare @store_name varchar(30); declare @sales int; declare @date datetime; select @store_name = i.store_name from inserted i …

Read More
Create a view with ORDER BY clause

I'm trying to create a view with an ORDER BY clause. I have create it successfully on SQL Server 2012 SP1, but when I try to re-create it on SQL Server 2008 R2, I get this error: Msg 102, Level 15, State 1, Procedure TopUsers, …

Read More