Posted by Erland Sommarskog on 02/02/06 00:56

Elham Ghoddousi (Ghoddousi@gmail.com) writes:
> Does Session term exist in SQL Server?
> If yes, when it creates, how can monitor it. And where does its
> information store?

Could you clarify what you mean with "session"? Do you mean when someone
connects to SQL Server? You can audit login/logout events from SQL Profiler.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]