Sessions?

Question

can some one explain what a session is?

if i write a query in a new window -  thats a  new session? 

if i run the query once - the sesion is over?

if i execute the query twice - this is the second session? 

some confusions .. 

Answer 1

Yes.. Opening a new query window in SQL Management Studio means its a new session

The session will last until connection is disconnected. How many query you execute they will all be part of same session.

---

Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs

Answer 2

have a look at this link

http://dba.stackexchange.com/questions/13698/what-is-the-difference-between-a-connection-and-a-session

---

Satheesh
My Blog | How to ask questions in technical forum