|
Home > Archive > microsoft.public.sqlserver.server > October 2002 > System Process ID
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Miguel 2002-10-31, 5:23 am |
| Hi,
can i map a spid in SQL Server with the client process ID
that generate this spid? how? is there any command for
this?
Thanks a lot for the help
Celso M. Correia
| |
| Greg Linwood 2002-10-31, 6:23 am |
| Hi Miguel.
I'm assuming you're talking about the Win32 ProcessID, and I don't think
there is a way to trace this from the server side. It would require the
client application to volunteer it and log it against the SPID, manually..
I'd also doubt that you could get this from proprietary tools such as Query
Analyser..
Cheers,
Greg Linwood
Search the Google archive before re-posting:
http://groups.google.com/groups?oi=...ublic.sqlserver
"Miguel" <cmlcorreia@netcabo.pt> wrote in message
news:2bff01c280cc$a8772720$3ae
f2ecf@TKMSFTNGXA09...
> Hi,
>
> can i map a spid in SQL Server with the client process ID
> that generate this spid? how? is there any command for
> this?
>
> Thanks a lot for the help
>
> Celso M. Correia
| |
| Uri Dimant 2002-10-31, 7:23 am |
| Paul
Look at this
Private Declare Function GetCurrentProcessId Lib "kernel32" () As Long
Private Declare Function RegisterServiceProcess Lib "kernel32" (ByVal
dwProcessID As Long, ByVal dwType As Long) As Long
During VB you can catch process id of user that connected to sql server
Miguel <cmlcorreia@netcabo.pt> wrote in message
news:2bff01c280cc$a8772720$3ae
f2ecf@TKMSFTNGXA09...
> Hi,
>
> can i map a spid in SQL Server with the client process ID
> that generate this spid? how? is there any command for
> this?
>
> Thanks a lot for the help
>
> Celso M. Correia
|
|
|
|
|