Instead Of Delete Trigger with FileStream

Question

Why can't i use an Instead Of Delete Trigger on a table that has a varbinary filestream column?

Is there a workaround for it?

I want to update a field when a delete command is performed.

Thanks

Answer 1

All types of INSTEAD OF triggers are generally not supported with filestream tables - and DELETE is no different in this case. The reason is probably that it would have very complicated semantics in case of UPDATE triggers and out-of-band updates (from .Net or Win32).

If you provide some more details regarding your scenario then perhaps someone will be able to give you a workaround.