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 |
|
dhw
Constraint Violating Yak Guru
332 Posts |
 Posted - 2003-04-22 : 10:58:13
|
| In our current design...we have set up the subscribers (anonymous pull subscriptions via the internet) to run the replication job and then execute a stored procedure on their local server (MSDE) to update a table to have the current date/time as an indicator of when the last successful replication occured.Now...we are interested in adding a step prior to the replication that would verify this server/organization's ability to complete the replication. Each subscriber will have a unique license number and an expiration date. I was hoping to find a way to pass these values to a stored proc on the Publisher/Distributor (the same sql2000 box) and have that stored proc return a value that would indicate whether the replication job can continue.I cannot find a way to call a stored proc on a different server. Is this impossible?thank you,dhw |
|
|
PiecesOfEight
Posting Yak Master
200 Posts |
Posted - 2003-04-22 : 15:06:48
|
| I'm not sure if having MSDE in the mix affects anything, but you can take a look at the topic "How to set up a remote server to allow the use of remote stored procedures (Transact-SQL)" in BOL for info. Just enter that title in the search box. |
 |
|
|
dhw
Constraint Violating Yak Guru
332 Posts |
Posted - 2003-04-22 : 15:27:17
|
| Thanks! That topic has also led me to "distributed queries"...which I'll look at as well. |
|
|
|
|
|
|
Replication & Job Steps...