sql server replication: when is Distribtutor Agent profile effective -- sql server replication

when is Distribtutor Agent profile effective

jeff_y
8/27/2007 6:07:11 PM

sql server replication: Hi gurus,
If I want to switch the distributor agent profile, for example, from the
system default profile to a new user-defined profile, I can do this from
Replication Monitor by Expanding a specific publication and then under "All
subscriptions" tab, right-click the subscription and select agent profile
from the popup window, and then in the new window, I can select the new user
customized profile, and then click OK.
My question is: after doing this, does the profile take effects immediately?
or should I restart the whole sql server agent service to let the new
profile take control?

TIA,
Jeff

Re: when is Distribtutor Agent profile effective

Hilary Cotter
8/27/2007 10:52:00 PM

While you can restart the entire SQL Server for the new profile to be
effect, all you really need to do is to restart the agent (stop and start
it). The new profile (or changes to a profile) will not be effective until
the agent is restarted.

--
RelevantNoise.com - dedicated to mining blogs for business intelligence.

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]