Menu
We have a big system with several hundred concurrent users so sql profiler gives a bit too much information without appropriate filters. I'd like to see what SQL commands are run under my account and my account only. With account I mean the username I use to log in to the system. These user names are stored in a regular database table and thus can't as such be entered to any filter in sql profiler, I guess? But every user that logs in might have some unique id anyway even thou we all use the same SQL login/user?
So, the question is mostly how to get that unique value and which filter to use? Or is there any way to see this and only this in sql profiler?
822
Events Selection tab To view this window, use SQL Server Profiler to open a trace table. Then on the File menu, click Properties, and then click the Events Selection tab.
Use SQL Server Profiler You can capture and save data about each event to a file or table to analyze later. For example, you can monitor a production environment to see which stored procedures are affecting performance by executing too slowly.
We are announcing the deprecation of SQL Server Profiler for Database Engine Trace Capture and Trace Replay. These features will be supported in the next version of SQL Server, but will be removed in a later version. The specific version of SQL Server has not been determined.
You should be able to get the hostname of the machine connecting to SQL server. In the Trace Properties/Event Section tab, tick the Show all Columns option then in Column Filters you can specify HostName.
If you want to know the hostname of a machine you are using then at the command prompt type hostname
170
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
