How to detect a login under windows security?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

nospam@tgylnospam.no - 01 Oct 2005 19:07 GMT

I have a SQL Server 2000 on an intranet with windows security. A stored
procedure is called every time users add orders into table ORDERS.

How can I detect the login name and domain for the user that adds a new
order? What would the lines of code look like in the stored procedure?

Regards

Tore G.

Reply to this Message

Mike Epprecht (SQL MVP) - 01 Oct 2005 20:29 GMT

Hi

SELECT SUSER_SNAME()

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

>I have a SQL Server 2000 on an intranet with windows security. A stored
> procedure is called every time users add orders into table ORDERS.
[quoted text clipped - 5 lines]
>
> Tore G.

Reply to this Message