all groups > sql server replication > june 2006 >
You're in the

sql server replication

group:

using - UseInprocLoader property


using - UseInprocLoader property maxzsim via SQLMonster.com
6/27/2006 12:00:00 AM
sql server replication: 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
Re: using - UseInprocLoader property Hilary Cotter
6/27/2006 12:00:00 AM
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]

Re: using - UseInprocLoader property maxzsim via SQLMonster.com
6/28/2006 1:33:39 AM
can do tks ..
[quoted text, click to view]

--
AddThis Social Bookmark Button