KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
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. How can I determine this?
Tags (comma-separated)
Save Edits
Cancel