hi Thanks for your quick reply..

Actually in my production environment there will be always approx..170 Users connected to the database.

out of those 170 i can able to see more than 100 is connection in sleeping mode..here i am planing to release that sleeping connections from active monitor.Can anyone help on this

?how can i able to achive this in SQL Server 2005.