Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Session ACTIVE or INACTIVE

Author  Topic 

fakru.y
Starting Member

1 Post

Posted - 2008-07-06 : 01:34:38
Can any one tell how to find out a session is active or inative in sql server, as iam very new to sql server

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2008-07-06 : 08:05:45
If you look under Current Activity yoiu can see what the state of all the connections.
Also, you can turn on Profiler to see the activity, there are filter options which allow you to define certain search parameters .



Jack Vamvas
--------------------
Search IT jobs from multiple sources- http://www.ITjobfeed.com
Go to Top of Page
   

- Advertisement -