May 9, 2005 at 3:18 am
I would like to set up SQL Profiler sessions to both trap and exclude connections via NT authentication.
This shows up in the as a NULL SQL login name.
When I am setting up a filter (either LIKE or NOT LIKE) how do I specify a NULL username rather than the text string "NULL"?
Tom.
May 9, 2005 at 6:35 am
Use -
WHERE username IS NULL
**ASCII stupid question, get a stupid ANSI !!!**
May 10, 2005 at 2:03 am
Can the filters be set up directly as queries?
Is there a free form entry box for queries?
Tom.
May 10, 2005 at 6:50 am
Apologies - I completely missed the "profiler" bit....
I'm experimenting with using the isnull function with the LIKE filter - will let you know if it works!
**ASCII stupid question, get a stupid ANSI !!!**
May 10, 2005 at 8:30 am
Tom - the closest I got was using 'isnull(ntusername, 'n') in the 'not like' filter - however, since I am not on a network right now it's difficult for me to test...maybe you can run a couple of test traces and see (unless you've already tried this)..
**ASCII stupid question, get a stupid ANSI !!!**
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply