Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-10-31 : 10:13:30
|
Ian writes "I have 2 SQL 7 Servers with identical database structures. One is inside the corporate firewall, the other outside, running the Internet Web Server. Push Replication is currently set up to occur every 12 hours.
I need the capability to initiate a Push replication Ad Hoc. I need to be able to start a replication programmatically or preferably via an ASP script on the Intranet machine. My initial thought was that it could be initiated via a stored procedure on the Intranet SQL Server, but I've found no evidence to support that.
Any ideas?
Thanks,
Ian
Both Servers running Windows NT 4 SP6
SQL 7, SP1" |
|
|
|
|
|
Forcing Replication via Stored Procedure?