The SQL that Chris provided is used at the consolidated database, and will let you know what script versions are defined, allowing you to verify that when you synchronize a remote database to this consolidated database, that the 'vup_1' script version exists at the consolidated database. If you would like to know which script version a remote database will use when you synchronize the synchronization subscription named 'uploadtope', you would execute the following SQL on the remote database : select script_version from SYS.SYSSYNC where subscription_name = 'uploadtope'; Reg answered 08 Dec '20, 08:54 Reg Domaratzki |
This information is in the MobiLink system table i.e., answered 08 Dec '20, 07:14 Chris Keating |
It's unclear to me exactly what you are asking. Both Chris and I have provided responses that answer the question correctly, but make different assumptions on what you are asking. If we haven't answered your question, please clarify your question.