orakid
Old Hand
Points: 304
More actions
July 22, 2011 at 5:43 am
#390033
I am confusing ,SQL Server makes the connection and handle multiple sessions ?,SQL Server make sessions ? if yes then which type of sessions ?
thanks in advance
sandeepivs
SSC-Addicted
Points: 494
July 22, 2011 at 6:08 am
#1356986
Hi Orakid,
We can maintain multiple sessions in SSMS using Dynamic Management View (DMV).
By using this keyword u can see how many sessions are opened sys.dm_exec_sessions
For further reference, u can go through the following link...
http://beyondrelational.com/blogs/nakul/archive/2011/01/17/the-multiple-connections-of-ssms.aspx
🙂
Thanks,
Sandeep
July 22, 2011 at 11:13 pm
#1357383
what is the type of session
STATELESS
STATEFULL
?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply