SQL Server Profiler - how do I find which database is being connected?
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?
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!
- database design of a family and how to insert into database
- Laravel: Selecting all films where the condiction is in another table
- wordpress mysql - delete all custom post type
- How to open file maker .fp3 files without file maker installed?
- How to restrict RLS on certain column(s) in PostgreSQL/Supabase?
- How to use stored procedure parameters as dynamic content in copy activity using ADF
- NLOG Database Target can't connect
- SQL Database in restoring mode
- Add PRIMARY KEY constraint to existing table
- How to debug a database query for performance
- LocalDB is not supported on this Platform
- Store images in a MongoDB database
- How to pass stored procedure parameters as dynamic content in copy activity using ADF
- Normalization of vehicle data
- sqlite's fetchall returns None instead of an empty list
- How do I join 2 SQL tables in python based on their (non-unique) ID and closest values in years?
- connect superset to postgresql in a docker container - The port is closed
- Is there a way to get a list of column names in sqlite?
- What happens when you insert rows in a SERIAL column with existing values?
- Relational Algebra Intersection Properties
- MySQL insert country iso or country id from another table
- Error: supabaseUrl is required (supabase) postgresql
- How do I alter the position of a column in a PostgreSQL database table?
- Utilizing Sqlite `no such table` error in Go?
- What this warning means `Required tables DBMSHP_FUNCTION_INFO,DBMSHP_PARENT_CHILD_INFO,DBMSHP_RUNS missing`
- Superset: command not found
- How do you interpret a query's explain plan?
- What is the difference between the different BerkeleyDB versions, and which should I choose?
- How to select bottom most rows?
- Export and Import all MySQL databases at once