Click here to Skip to main content
15,881,882 members
Please Sign up or sign in to vote.
3.00/5 (2 votes)
See more: , +
SqlConnection con=new Sqlconnection("Data Source=...")
con.open();
when I opened a Connection through .Net Application
and I have executed this select query in Sql Server
SQL
Select SESSION_ID,
C.CONNECT_TIME,
C.CONNECTION_ID, 
C.NUM_READS,
C.NUM_WRITES from  SYS.DM_EXEC_CONNECTIONS .

I found connectionids, sessionids.
for every request from applications will it creates
new ConnectionId and Session id ?

what are the difference between sessionid and connection id
If I create #tempTable through application is it unique for each client login
I tried a lot by googling , i did't find please help out
Posted
Updated 28-Jun-15 18:48pm
v5
Comments
Suvendu Shekhar Giri 27-Jun-15 9:58am    
Not sure but as far as I know, Connection_Id should be unique.
Check if following link is helpful
Unique Connection ID in sql server

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900