How do I delete an Attachment?

[JeffKoski]

I accidently added the wrong attachment and now need to delete it. Do I have to go into SQL server and manually delete?

[lbauer]

There's no way to delete attachments from Dragnet itself. You can delete rows from the attachments table in the sgdragnet database. Be sure to backup your database anytime you modify the database directly.

[JeffKoski]

I only have one row in the attachment table which has the name of the doc I want to delete. I can delete this row, but is there any other clean up that has to be done? I do not see where the actual doc was stored. Thanks.

[jclausius]

A better way to do handle this would be through the stored procedure.

Assuming you know your :
a) User's ID (SELECT uid, name FROM sgdragnet.dbo.users)
b) Message / Attachment IDs (SELECT filename, msgid, attid FROM sgdragnet.dbo.attachments )


Call

Code: Select all

EXEC sgdragnet.dbo.spdeleteattachment @uid, @msgid, @attachmentid