"frankm" <frankm@nospam.postalias> wrote in message
news:%23jw3IVn7EHA.3596@TK2MSFTNGP12.phx.gbl...
> I'm looking for an explanation of the -UseInprocLoader parameter.
> Everywhere I look I see the stock definition with no explanation of what
it
> actual is and does.
> Can any one define what this parameter does or is?
>
>

"Paul Ibison" <Paul.Ibison@Pygmalion.Com> wrote in message
news:%239$gdHq7EHA.1188@tk2msftngp13.phx.gbl...
> As far as I recall, this works with the -MaxBCPThreads parameter to get
> parallel processing working.
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>

"Hilary Cotter" <hilary.cotter@gmail.com> wrote in message
news:%23UEgoGr7EHA.824@TK2MSFTNGP11.phx.gbl...
> Paul is quite correct, this parameter must be used in conjunction with
> MaxBCPThreads for optimal performance, and should only be used on multi
> processor subscribers.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> "Paul Ibison" <Paul.Ibison@Pygmalion.Com> wrote in message
> news:%239$gdHq7EHA.1188@tk2msftngp13.phx.gbl...
> > As far as I recall, this works with the -MaxBCPThreads parameter to get
> > parallel processing working.
> > Rgds,
> > Paul Ibison SQL Server MVP, www.replicationanswers.com
> > (recommended sql server 2000 replication book:
> > http://www.nwsu.com/0974973602p.html)
> >
> >
>
>

"Paul Ibison" <Paul.Ibison@Pygmalion.Com> wrote in message
news:uSkfIUa8EHA.1188@tk2msftngp13.phx.gbl...
> I think this is Proc as in 'process' rather than procedure, which accounts
> for the increased speed, relative to using out of process ODBCBCP. In each
> case it loads a text file, but BOL explains that BULKINSERT is faster than
> BCP.
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>