Download and run the ClearOrphans script and then schedule it as a job in SQL Server 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.
Connect and collaborate with fellow Blackbaud users.