>>>>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
UniversalThread is the best forum for VFP developper! You are great! :)
Giedrius