That would be normal because the subscription is expecting the value to be present. Since it is not, you are getting a null in return and the whole value then becomes null.
If the values are necessary for the report, why would any of them get deleted?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events