0

How can I Filter only my calls to Shared SQL Server using a shared login account when debugging?

I am using SQL Profiler and was curious if anybody knows the Column Filters I can use to focus only to my calls.

I have the LoginName set to the Account that multiple users are using and that still does not filter enough.

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Moojjoo
  • 729
  • 1
  • 12
  • 33

1 Answers1

1

You can use the SPID column.

Find out what SPID you are using (if profiling from SSMS, it is in the status bar) and filter by it.

Another option is to include an application name (possibly with the specific machine name) in the connection string and filter by it.

Oded
  • 489,969
  • 99
  • 883
  • 1,009
  • You said **PID** did you mean **SPID**??? Also I do not see that in the status bar of SSMS. – Moojjoo Jul 10 '13 at 20:47
  • @Moojjoo - in the status bar, when you have a query window open, you will see the user name and SPID `username (spid)`. And sorry, yes, it is SPID, not PID. – Oded Jul 10 '13 at 20:50