Orphaned Attachments

Reply

Jeff Salutz Posted: Thu, Dec 1 2011 2:37 PM

rated by 0 users

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 Salutz
Salutz & Salutz LLP
Manitowoc, WI 

Reply

Wells Anderson, J.D, CIC replied on Fri, Dec 9 2011 5:44 PM

rated by 0 users

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:

http://www.tmtools.com