Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL Server 2000 Profiler

Status
Not open for further replies.
icemel

icemel

MIS
Oct 17, 2005
463
US
Hi,

For some reason, I've had poor results using Profiler (2000).

Specifically, I am trying to find all object references for a given "DBUserName". I want to find out which tables, etc this particular database user is accessing.

I created a filter on DBUserName where like = Username. I've also tried like = '%Username%'.

However, when I run the trace, the DBUserName column is completely blank! It doesn't even show that I'm profiling the correct DBUserName.

Can't figure this out. I've had similiar problems when filtering on different criteria. It all but seems to ignore the filtering. Am I doing something wrong here?

Thanks
 
Status
Not open for further replies.

Similar threads

V
  • Locked
  • Question
xp_cmdshell vs psexec - this SQL server forgets credential to an W10 share
Replies
0
Views
685
Volvere
V
gbaughma
  • Locked
  • Question
SQL Performance
Replies
11
Views
827
pjw001
pjw001
Steve Yu
  • Locked
  • Question
How secure is MS SQL on the Internet vs behind firewall inside a LAN 1
Replies
3
Views
424
Chris Miller
Chris Miller
elly00
  • Locked
  • Question
create sql view using batch file
Replies
5
Views
510
Mike Lewis
Mike Lewis
grnzbra
  • Locked
  • Question
T-SQL Dialog Box
Replies
8
Views
482
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top