I have found quite a few orphaned email attachments in the "attach" table. I have verified these are orphoned by doing a search of all my emails. What is the best way to clear these out. Do I just use Sql Server Management Studio and delete them?
Jeff SalutzSalutz & Salutz LLPManitowoc, WI
Jeff, after making a good backup of the database, you can go ahead and delete the orphaned attachments as long as you are familiar with doing so using SQL Server Management Studio.You cannot work with orphaned attachments from within Time Matters.
Mark Deal developed a utility, TMTools, that automates the process of working with attachments. You can read about it and buy it here:
Wells Anderson, JD, CIC / Moderator800.575.0007 - Edina, MN - © 2012
www.activepractice.comFree Time Matters Webinars monthly on the second Friday