is it possible to stop replication in cmd prompt for MSSQL2005 Thanks in advance!
stop replication in cmd prompt
Hot Topic
- sql autoincrement
- Setup failed - no package <sqlncli.msi>
- What is necessary to create SDF-Files on desktop legally?
- transfering multiple objects to another schema
- (This site might require the following ActiveX control: ‘Microsoft SQL Server 2000 Reporting Services’ from Microsoft Corporatio
- Create Extended Procedures in VS 2005
- Sql Server 2005 Client Configuration Manager
- Subreport Processing
- Convert numbers to Month Name
- Stored procedure parameter without type
SQL Server
- Sequencial Desgin Limitation on DataFlow Task?
- IBM Informix Ole Db Provider
- casting integer to month
- Is anyone using C# and the SSIS Objects to Develop/Modify Packages?
- Setup ODBC problem using SQL Express
- Failed to decrypt XML node "DTS:Password"
- Licensing question, and other report building tools
- Drillthrough Functionality via Excel Add-in
- Run SSIS Package from SQL 2000
- Transformation script last row
stop replication in cmd prompt
PJFINTRAX
You can use the sqlcmd.exe to start and stop various replication agents using the following system stored procedures:
sp_start|stoppublication_snapshot (at publisher)
sp_start|stop[merge]pushsubscription_agent (at publisher)
sp_start|stop[merge]pullsubscription_agent (at subscriber)
Or, if replication is the only thing running on SQLServerAgent, you can simply stop SQLServerAgent instead.
-Raymond