>>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.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham