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 - 2004-01-16 : 08:08:34
|
| Mary writes "I am using SQL Server 2000 to replicate data to a remote MSDE. I am using a pull subscription on my MSDE. I need to be able to programmatically stop the pull subscription and then programmatically restart it.I am currently trying to use stored procedures. I do not know how to stop the pull subscription using a stored procedure. I think I should be able to restart it using sp_reinitpullsubscription. However even after reinitializing the subscription, I must somehow get the snapshot agent on the server to run. What is the stored procedure to stop a pull subscription?What is the stored procedure to start the snapshot agent?" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-01-16 : 12:36:15
|
| Starting and stopping of replication is done through the jobs. Take a look at your job in the SQL Server Agent.Tara |
 |
|
|
|
|
|
Replication stored procedure to start snapshot agent