Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
agapimu6969
Starting Member
9 Posts |
 Posted - 2008-01-14 : 08:18:24
|
| Hi all,Anyone can tell me how I can take out the events which produce SSMS? (open query windows create three rows). I don't see anythinq filter for SSMS in filter events of profiler. I'm doing at trace and this is not confortable.Thanks. |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-01-14 : 08:20:02
|
| filter by application name._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com <- new version out |
 |
|
|
agapimu6969
Starting Member
9 Posts |
Posted - 2008-01-14 : 08:32:21
|
| The problem is that I'm working with ssms, so the applicationname is the same. |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-01-14 : 08:37:36
|
| i'm not quite sure what you mean then.what exactly would you like to filter?_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com <- new version out |
|
|
|
agapimu6969
Starting Member
9 Posts |
Posted - 2008-01-14 : 08:47:07
|
| I'm checking several store procedures which sent me. I'm working in SSMS and the problem is that for example when I do somethinq in SSMS for example open a new query windows this log in the profiler. I only want to see the trace of stored and don't see any trace of ssms.I don't know if I explained well, but if you go to profiler and run a new trace and then you open a new query window you can see that this event produced three rows in the trace |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-01-14 : 08:51:44
|
| you can easily filter your trace.import it into a table and you can perform normal sql filtering on it._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com <- new version out |
|
|
|
|
|
|
Trace Profiler SSMS