Idle Connections

[AmitInnani]

How to kill the orphaned or idle connections in MS SQL Server?

As those unwanted connections, are making my system not to work properly and not allowing me to access the database if the number of the connections are reached.

Can anybody tll me haw to close the unwanted idle connections?

Thanking you! :wave:

[Krzemo]

http://support.microsoft.com/default.aspx/kb/137983/EN-US/?

Hope it helps.

[AmitInnani]

Thanks For the help. :wave: