Hello,
first you should have in mind that the object delete rule will not harm objects that are already disconnected from the SQL-MA, only the next object which will be disconnected from that MA will be deleted from the MV, current objects will remain and you have
to clean up them manually, or reconnect and then disconnect them.
MV deletion will happen on the Sync, so there is only one way to check if that works like designed (and it will be, object delete is a quite simple function).
Check the Import History for disconnectors and do a Preview (Full/Delta) Sync on them, check this for some of the objects.
If you need this every time objects disconnects from SQL MA, then write a little script that checks Import History (use WMI on that) for deleted imports and verify the output, if everything is ok do the sync.
Regards
Peter
Peter Stapf - Doeres AG - My blog:
JustIDM.wordpress.com