These instructions are correct for SQL 2000 servers managed by Enterprise
Manager. They are for accessing the agents through the agents, folder. You
can also do it, as you have noted, through the subscription folder. My
understanding is that this is a distribution agent option.
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com [quoted text, click to view] "maxzsim via SQLMonster.com" <u14644@uwe> wrote in message
news:6264dca1a4b30@uwe...
> Hi ,
>
> This is from BOL : where it said it can improve on the performance on
> Generating & Initializing snapshot
>
> How to set the - UseInprocLoader property (Enterprise Manager)
> On the server where the Distribution Agent or Merge Agent is running,
> expand
> the Replication Monitor node, click the Distribution Agents or Merge
> Agents
> folder, right-click the agent that will be applying the snapshot, and then
> click Agent Properties.
>
>
> On the Steps tab, double-click the subscription agent step, and then add
> the
> -UseInprocLoader property in the Command text box.
>
>
> Does it actually means go to Replication Monitor --> look for the
> subscription involved --> right-click snapshot's Agent Properties --> go
> to
> Steps --> Run Agent and add in the -UseInprocLoader at the last of the
> command window ?
>
> or even if it does not meant what i thought it was , can i add it to the
> Run
> Agent's command window ?
>
> appreciate ur advise
>
> tks & rdgs
>
> --
> Message posted via SQLMonster.com
>
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-replication/200606/1