>>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


Btw, SQL's

HOST_NAME()

gives workstation name, part of sys(0)