I am working on implementing an ETL process to load data into a warehouse.
Part of this process is pulling data from our production server (Server P) to a staging server where the actual load into the warehouse (and the warehouse itself) is located (Server S). We are using snapshot replication for this.
For QC and some other purposes, I need a way to determine the date that the snapshot was taken on Server P, from Server S. Linking servers for this query I don't think is an option.
I'm hoping that there is a record in a metadata table somewhere to reflect this, or some other command I can run to query the snapshot history.