On Mar 28, 4:56 am, "Agnes" <a...@dynamictech.com.hkwrote:
when One user open the application, he will access around 5 database
so there will be 5 spid in the sql server , right?
if there are 200 hundres user , there will be 1000 right?
I don't think so. By running sp_who2 I can see that there is only one
SPID when I make a connection. You'll probably get a more accurate
response in sqlserver group though.
Brian