Processor affinity.

Is there any way of finding out which processors a SPID is
executing on?I am not 100% sure, but I think profiler will show the proc#.. ( could be
mistaken tho.)
--
Wayne Snyder MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
(Please respond only to the newsgroups.)
I support the Professional Association for SQL Server
(www.sqlpass.org)
<KJGNews@.hotmail.com> wrote in message
news:efaW6PywDHA.2460@.TK2MSFTNGP10.phx.gbl...
> Is there any way of finding out which processors a SPID is
> executing on?
>