<?xml version="1.0" encoding="utf-8" ?>
<?xml-stylesheet type="text/xsl" href="RSS_xslt_style.asp" version="1.0" ?>
<rss version="2.0" xmlns:WebWizForums="http://syndication.webwiz.co.uk/rss_namespace/">
 <channel>
  <title>Spam Filter ISP Forums : MSSQL trigger to lower quarantine</title>
  <link>https://www.logsat.com/spamfilter/forums/</link>
  <description><![CDATA[This is an XML content feed of; Spam Filter ISP Forums : Spam Filter ISP Support : MSSQL trigger to lower quarantine]]></description>
  <pubDate>Sat, 17 Oct 2026 05:03:38 +0000</pubDate>
  <lastBuildDate>Wed, 01 Aug 2007 07:01:30 +0000</lastBuildDate>
  <docs>http://blogs.law.harvard.edu/tech/rss</docs>
  <generator>Web Wiz Forums 11.04</generator>
  <ttl>360</ttl>
  <WebWizForums:feedURL>https://www.logsat.com/spamfilter/forums/RSS_post_feed.asp?TID=6169</WebWizForums:feedURL>
  <image>
   <title><![CDATA[Spam Filter ISP Forums]]></title>
   <url>https://www.logsat.com/spamfilter/forums/forum_images/web_wiz_forums.png</url>
   <link>https://www.logsat.com/spamfilter/forums/</link>
  </image>
  <item>
   <title><![CDATA[MSSQL trigger to lower quarantine : Here is a trigger I had written...]]></title>
   <link>https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6169&amp;PID=10588&amp;title=mssql-trigger-to-lower-quarantine#10588</link>
   <description>
    <![CDATA[<strong>Author:</strong> <a href="https://www.logsat.com/spamfilter/forums/member_profile.asp?PF=219">TechSquared</a><br /><strong>Subject:</strong> 6169<br /><strong>Posted:</strong> 01 August 2007 at 7:01am<br /><br /><P>Here is a trigger I had written to limit the quarantine to people that are actually checking it.&nbsp; Basically it checks the DB when a line is inserted into the quarantine table and marks it to be deleted if there is not a corresponding user in the logins table.&nbsp; It has saved me a ton of space for non-existent users, or users that don't check the quarantine.</P><P>IF (SELECT COUNT(*) FROM &#091;dbo&#093;.&#091;tblLogins&#093;, &#091;inserted&#093;<BR>&nbsp;&nbsp;&nbsp; WHERE &#091;dbo&#093;.&#091;tblLogins&#093;.&#091;EMail&#093; = &#091;inserted&#093;.&#091;EmailTo&#093;) &lt; 1<BR>BEGIN<BR>&nbsp;&nbsp;&nbsp; UPDATE &#091;dbo&#093;.&#091;tblQuarantine&#093;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SET &#091;Expire&#093; = 1<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; WHERE &#091;QuarID&#093; = @@IDENTITY<BR>END</P><P>This is after an insert to the tblquarantine.&nbsp; It has worked wonders for me.</P><P>Tech Squared</P>]]>
   </description>
   <pubDate>Wed, 01 Aug 2007 07:01:30 +0000</pubDate>
   <guid isPermaLink="true">https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6169&amp;PID=10588&amp;title=mssql-trigger-to-lower-quarantine#10588</guid>
  </item> 
 </channel>
</rss>