Extended SP Questions

[Bruce]

I would like to know if I can determine the calling user from within
an extended stored procedure. I assume it's accessible in the
SRV_PROC structure somewhere.

Also, does anyone know of a comprehensive list of what is included in
the SRV_PROC structure?

This is for SQL Server 2000.

Thanks

[Craig Kelly]

"Bruce" wrote:

I would like to know if I can determine the calling user from within
an extended stored procedure. I assume it's accessible in the
SRV_PROC structure somewhere.

Also, does anyone know of a comprehensive list of what is included in
the SRV_PROC structure?

This is for SQL Server 2000.

Thanks

My understanding is that SRV_PROC is intended to be an opaque structure and
as such you shouldn't hack it for production purposes (I mean, running my
own C/C++ in the process space of a production SQL Server gives me the
heebie-geebies anyway).

That being said, what about srv_pfield? It seems to provide quite a bit of
information...

Craig

[Bruce]

Thanks, srv_pfield worked great.