System Process ID 
Author Message
 System Process ID
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



Mon, 18 Apr 2005 12:00:00 GMT
 System Process ID

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=djq&as_ugroup=microsoft.public.sql...


Quote:
> 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



Mon, 18 Apr 2005 13:06:31 GMT
 System Process ID
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


Quote:
> 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



Mon, 18 Apr 2005 13:40:34 GMT
 System Process ID
Thanks Greg and Uri, i found that i can trace this with
profiler. You can trace the win32 process ID that
generated certain spid in SQL Server.

Thanks again

Miguel

Quote:
>-----Original Message-----
>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
>.



Fri, 22 Apr 2005 11:32:25 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. Error: Process ID %d is not an active process ID

2. Msg 6106,Sev 16: Process ID 67 is not an active process ID.

3. Msg 6106,Process ID %d is not an active process ID.

4. How do we know if a process is user process or system process

5. Query to tie Rollback to Session ID/Process ID

6. Linking Unix Process Id's back to Session Id's

7. Process ID 216:1112 owns resources that are blocking processes on Scheduler

8. Process ID killed by unknown hostname

9. How the Number of the session opened (process ID) impact the different sesstion

10. Theory Question about Process ID

11. Determining Process Id

12. bad process ID (SPID)


 
Powered by phpBB® Forum Software