Frederick,

Whatever you do you'll need to open port 1433 on the firewall to let the two
servers talk to each other using SQL. The actual code could be as simple as a
stored-procedure or script that you call from SQL Agent on the schedule that
you want. (SQL Agent is a job scheduler amongst other things)

> I have two database servers. One is an external box and one is an
> internal box residing behind our corporate firewall. I would like to
> copy data from one table when a record is inserted from the external
> box. This record would then be copied from the external box to a
> table residing on the intrernal box DB. I do not think this can be
> done b/c of the firewall.
>
> So... I need to setup some kind of scheduled call in SQL Server on
> the Internal server to go out and search the external database and see
> if any records exist in this table. If records exist, I want to pull
> that data back down to the internal box and save it.
>
> I can easily write a program (I would use VB) but I was wondering if
> anyone new a way to keep it all in SQL Server. Can anyone help?
>
> Thanks in advance.
>

Neil Pike MVP/MCSE. Protech Computing Ltd
Reply here - no email
SQL FAQ (484 entries) see
http://forumsb.compuserve.com/gvforu...?SRV=MSDevApps
(faqxxx.zip in lib 7)
or http://www.ntfaq.com/Articles/Index....partmentID=800
or www.sqlserverfaq.com
or www.mssqlserver.com/faq