Extended SP Questions

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"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|||Thanks, srv_pfield worked great.