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