CIC Solutions Forums
Certified Independent Consultant Solutions Forums for
LexisNexis® Practice Management Products
Time Matters - PCLaw - Billing Matters - Browser Edition - HotDocs

Orphaned Attachments

rated by 0 users
This post has 1 Reply | 2 Followers

Top 150 Contributor
Posts 14
Jeff Salutz Posted: Thu, Dec 1 2011 2:37 PM

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 

Top 10 Contributor
Posts 1,196

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 / Moderator
800.575.0007 - Edina, MN - © 2012
Free Time Matters Webinars monthly on the second Friday

Page 1 of 1 (2 items) | RSS