Home / user-30054

JoeB's questions

Martin Hope
JoeB
Asked: 2011-10-20 05:59:55 +0800 CST
  • 3

I have an issue where I want to strip some image attachments from emails.

Using Forefront for Exchange I can create a file filter rule based on attachment name, type, and size. This initially seemed promising as I could filter all messages of type PNG with a name of image???.png less than 5K in size.

However, the two problems I can’t figure out how to get around are

  1. this rule applies to all messages and I could not figure out how to narrow it down to only specific recipients

  2. it looks like the rule would strip the attachment but then replace it with message text indicating the attachment was striped. I could not find an option to silently strip the attachment.

exchange attachment microsoft-forefront-2010
Martin Hope
JoeB
Asked: 2011-09-14 12:21:48 +0800 CST
  • 1

My company just added 5 of the social networking images to its email signature. Now we have tons of copies of these identical images stored in the software that takes emails and turns them into tickets of some kind (Jira does this, but this isn't the only one we have with this problem).

Is there a way to block these on the SMTP level, or at the Exchange level, if I know the exact image? Maybe there's a way to block a PNG of size 25x25 automatically somehow?

EDIT1

If I stop these at the ticket system level, I will have to do it many times in different places. Still looking for a way to do this at the Exchange level. I found this link after reading the latest answer:

http://technet.microsoft.com/en-us/library/aa998825.aspx

Hoping it or a related topic will have a solution. Thanks again.

EDIT2

Looks like the only way to do this in Exchange is to block by file size, and since they all have different sizes we need 5 rules. This is still simpler for us than blocking at every application point that is storing these images.

Thanks for the help.

email exchange smtp exchange-2010 images
Martin Hope
JoeB
Asked: 2011-04-18 09:35:32 +0800 CST
  • 1

Yet I get no 'previous errors'. The line it gives me (by double clicking in SSMS) shows the second alter statement as the culprit:

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_A_Audit_AuditTypeID]') 
AND parent_object_id = OBJECT_ID(N'[dbo].[A_Audit]'))
ALTER TABLE [dbo].[A_Audit]  WITH CHECK ADD  CONSTRAINT [FK_A_Audit_AuditTypeID] FOREIGN KEY([AuditTypeID])
REFERENCES [dbo].[T_Type] ([TypeID])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_A_Audit_AuditTypeID]') 
AND parent_object_id = OBJECT_ID(N'[dbo].[A_Audit]'))
ALTER TABLE [dbo].[A_Audit] CHECK CONSTRAINT [FK_A_Audit_AuditTypeID] 
GO

Now when I try to remove this piece of the script, I get the same exact error on a different alter constraint statement that's pointing to the same table (T_Type).

The same unaltered script works fine on our TEST database, which is a schema perfect match for our production database. This leads me to believe there is some external factor making this script work in test but not in production.

I was able to find two major differences between our production and test machines:

  • The production database machine recently had CommVault software installed. On a different database within the same company, this CommVault installation broke other scripts. (Yes, I realize I could provide more information here - I'm working on getting it now)
  • Production is SQL 2005 SP4, while test is SQL 2005 SP3 (9.0.5 vs 9.0.4053).

Any help is greatly appreciated.

sql-server backup sql