Why Does Sql Server Ce Not Allow This Trigger To Fire?

We're using a SQL Server CE database. I understand that there are limitations to the types of trigger that work with a SQL Server CE database. For instance, the trigger on a SQL Se

Solution 1:

I don't think it matters whether the table is tracked as part of CE synchronisation or not.

Triggers are not supported in SQL Server Compact Edition 4.0

Differences Between SQL Server Compact and SQL Server

EDIT

According to this MSDN article RDA in SQL Server CE allows triggers on a SQL Server table that RDA pulls data from. It also states that for tracked tables SQL Server triggers can be executed when changes are pushed back to SQL Server.

Triggers. SQL Server Compact Edition does not support triggers. However, triggers can reside on the SQL Server table that RDA pulls data from. For tracked tables, the SQL Server triggers can be executed when changes are pushed back to SQL Server. You might have to specify SET NOCOUNT ON in the trigger logic. This indicates not to return the number of rows affected, because a response of "no rows affected" causes an error for the RDA Push method.

I would check that you are using SET NOCOUNT ON within your trigger.

Having said all this, and as mentioned above, the use of triggers in SQL Server CE are not supported.

Maybe a better solution would be to create a queue table of emails that are required to be sent. When this data is pushed from SQL CE back to your SQL Server you could schedule a SQL Agent job to check the queue table and send mail that way.