>>>>Hi,
>>>>
>>>>When a VFP application connects to a SQL Server, should the value of

@@SPID

be different for every user (from different PC)?
>>>
>>>I'm guessing that unless you're using any kind of connection pooling, each value should be different.
>>>
>>>Here's a way to test - while people are connecting (or even if you do test connections), run a query against sys.sysprocesses. That should tell you for certain
>>
>>I added a code to my application to log this value, for every user. I am thinking that one of my customers (the one I am having a problem with, if you have seen my other thread) is using a Terminal Server and all users get the same session ID. Therefore, if I am correct, they are all on the same session. This would explain the problem.
>>Thank you.
>
>You could be right. Admittedly I don't know all the ins and outs of connection pooling, how Terminal Server handles things, etc. - but I do know that querying sys.sysprocesses should give you the answer.

I am not sure that sys.sysprocesses gives me the answer 100%. One thing I see that the hostname for ALL users is the same, the name of the application server (e.g. MYAPPSERVER). (For other customers, each row of the sys.sysprocesses has the hostname as the actually computer name from which they run the VFP application). So I know that this customer is using Terminal Server (or some other similar technology. They are in Georgia and the servers are in Massachusetts). And I see in the sys.sysprocesses several entries with the same hostname but different SPID. So I don't know if this is when a user logs in and logs out. Or all users - even though connecting through the same host - are getting unique SPID.