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
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