>>>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)
Yes:) There are tons of them. Clouldn't list all. Check sp_who too.
Cetin