Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
At At SPID
Message
From
14/07/2016 21:08:42
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Miscellaneous
Thread ID:
01638419
Message ID:
01638421
Views:
55
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform