To clear the inactive user connections in the database:
  1. Download the ClearOrphans script.
  2. Schedule it, as a SQL job, to run at your preferred interval (Example: every 30 minutes).


Please consult with a qualified SQL Server administrator or with Microsoft regarding how to create a scheduled job in SQL Server. For more information, see Microsoft's article How to: Schedule a Job (SQL Server Management Studio).

Note: We provide links to third-party websites in an effort to help you resolve your issue. We are not responsible for the information on third-party websites, and we cannot assist with implementing resolutions from these websites.