I need to generate a number in second from midnight.
Example the reporting time is 7:50 AM , 84600 second in the day minus 28500
(Start Time in Seconds) =58200 Seconds from midnight
Thanks

I've been doing direct replication on my databases for years now, and
I'm looking into switching to indirect replication to work over a WAN
which we just setup with a VPN.  Everything I read says I need
Replication Manager to do indirect replication.  How do I buy this?

I have a design master with two replicas that use direct sync.  It has worked
for years with no problems other than the occasional corruption which I have
fixed.  Recently replication stopped working and I get the error "The search
key was not found in any record."  As far as I can ...