• 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