>>I have a desktop application (VFP9) which runs in a Windows Network. I always used applications users to log into it, but now I need to develop auditing mechanisms on the database and I guess using native SQL Server users and/or Windows users would ease programing this. Which way should I choose? Their use is conditioned to something?
>>
>>By the way, and I guess this would effect which kind of users to use, now we are working on the same LAN, but we are planning to do remote work, in other words most of the users will work from their homes.
>>
>>TIA
>
>In my apps, the SQL user that connects to the DB is always the same, that wouldn't tell much.
>I use the user who logged into the application - not the Windows user or the SQL user, for logging and that seems to work well.

I do the same in my apps. Do you have the need to know who changed the value of certain field of certain table? I have that need, and I can't do it with one SQL user I think is very tricky to do it. But every user having his own login would ease a lot the programming.

Thanks.