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 |
|
Kiani
Starting Member
4 Posts |
 Posted - 2008-04-19 : 05:54:49
|
| Hi SirsI want to trace any connections to a database from Query Analyzer or EM.When I create a trace ,I filter in "application Name " this value : SQL% and in "DatabaseId" with 7(for example), but when run the trace, it shows all applications and doesn't work filter SQL%.What is the reason?Thank youKiani |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-19 : 16:56:03
|
| Connect to sql server with em and query analyzer then run sp_who2 to find out program name of them, set filter with those names. |
 |
|
|
Kiani
Starting Member
4 Posts |
Posted - 2008-04-20 : 03:55:54
|
I know the name of these programs but when I set these names in filter values, it doesn't correctly and shows all programsquote:
Originally posted by rmiao
Connect to sql server with em and query analyzer then run sp_who2 to find out program name of them, set filter with those names.
|
|
|
|
|
|
|
SQL Profiler