Re: get the windows user from SQL server



Look at BOL, in the Functions:

CURRENT_USER
SYSTEM_USER
USER
USER_NAME
(SUSER_NAME)

HTH, Jens Süßmeyer

---
http://www.sqlserver2005.de
---

"Petxa" <pecharroman2001@xxxxxxxxxxx> schrieb im Newsbeitrag
news:eryji3LQFHA.2972@xxxxxxxxxxxxxxxxxxxxxxx
> Hello,
>
> I have an application that use SQL server, (the conexion is not by nt
> autentification)
>
> I need to know what is the current windows user.
>
> Any help will be appreciates.
>
> Thanks Diego
>
>


.



Relevant Pages

  • Re: SQL Server Developer Edition Connection Limit?
    ... HTH, Jens Süßmeyer. ... > Once and for all because there is no information posted on the SQL Server ... > Website. ...
    (microsoft.public.sqlserver.setup)
  • Re: MS SQL-Server Express licensing
    ... SQL Server is free to use:-) ... HTH, jens K. Suessmeyer. ...
    (microsoft.public.sqlserver.msde)
  • Re: User SQL access problem
    ... do you want to use SQL Server authentication or Windows authentication ... Is the Sql Server and the users connecting in the same domain? ... HTH, Jens K. Suessmeyer. ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL Sever Version
    ... SQL Server 2005 is available now? ... > HTH, Jens Süßmeyer. ... Prev by Date: ...
    (microsoft.public.sqlserver.setup)
  • Re: Wartungsplan schlägt teilweise fehl
    ... aus BOL SIMPLE is the default setting for SQL Server Personal Edition ... Die master-DB hat immer simple. ... Sicherung der Datenbank und alle Sicherungen der Tranaktionslogs. ... Lesestoff dazu im "SQL Server 2000 Operations Guide": ...
    (microsoft.public.de.sqlserver)

Loading