>Hello,
>
>Situation:
>Front-end: VFP 8.0 SP1
>Back-end: MS SQL Server 2000
>Connection via ODBC with SQL Server authentication.
>
>Problem:
>When user makes changes on data, I want that trigger which fires could get UserName which User logged into workstation.
>
>I found one solution: to change Application name, then SQL server can get user id via SQL function app_name().
>The problem is that Application.Name is read-only in VFP and allways contains "Microsoft Visual Foxpro".
>How to change Application.Name value? Is it possible?
>
>Thanks in advance,
*VFP
Application.ServerName && Full path and filename of executable
sys(0) && Network name
*SQL server
SUSER_ID
SUSER_NAME
SUSER_SID
SUSER_SNAME
@@SPID
USER
USER_ID
USER_NAME
CURRENT_USER
SYSTEM_USER
...
Cetin