Geoff,

SQL Server does not possess a "deleted" flag, and anything deleted is G-O-N-E gone.

You could make your own, I suppose, but then you'd know the passthorugh to be used.

cheers


>Hi
>
>I wish to retreive deleted rows from a remote database (eg SQL Server or VFP).
>
>Can I do this via a view?
>
>If not what would the passthrough SQL be?
>
>Regards
>Geoff Scott