- We have SQL Server Management Studio 2005 SP3 on all of our Servers.
- We have 1 Main Server, and 1 Secondary Server that has the database from the Main Server being replicated on it. (If it matters, this is a "Pull" replication instead of a "Push" replication)
Question: Is there a way to use the Alerting tools in SSMS 2005 to start a Windows Service on the Secondary Server in the event of Replication Failure?
If not, is this feature available in a newer version of SSMS?