May 29, 2013 at 7:11 am
Hi Friends,
I am trying to track a multi user application . I am one of the user. I want to check some tables. So i am trying to enter some data through application to check what are all the tables are affected. When i track that using SQL profiler, it is getting all the informations which are done by all the users... So i am unable to see the information only that i need. Is it possible to filer by user or with something? I am new to SQL profiler. SO if my question does not make any sense, sorry guys.
Any suggestions would be really appreciated.
May 29, 2013 at 7:27 am
prakashr.r7 (5/29/2013)
Hi Friends,I am trying to track a multi user application . I am one of the user. I want to check some tables. So i am trying to enter some data through application to check what are all the tables are affected. When i track that using SQL profiler, it is getting all the informations which are done by all the users... So i am unable to see the information only that i need. Is it possible to filer by user or with something? I am new to SQL profiler. SO if my question does not make any sense, sorry guys.
Any suggestions would be really appreciated.
After you connect with profiler and before you hit run you should be on the Trace Properties screen. Click the tab labeled Events Selection. On the bottom right there is a column filters button.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply