How to change replication agent's default profile properties....

Hi,
my problem is: we have poor line between servers. To avoid this issue i
created new profile for distribution agent. This profile has been
created with bigger QieryTimeout and LogonTimeout values. After that i
assigned this profile to distribution agent and SQL Server agent was
restarted after this. According to new settings replication works fine.
But: i've found, that may be my boss, may be somebody else rolled back
all my changes and restored "system default" profile for distribution
agent. After this replicaion fault every time. So every morning i
assigned my profile, every night "default" profile has been restored.
My question is: is it possible to change "default" profile settings? I
saw MSdistribution_agent table, found job description, where profile_id
= 4. Where i should looking for details of profile settings?
Thanks a lot in advance.
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
We do not recommend updating the default profile, I'm not quite sure if i
understand what you mean by "rolled back" changes.
What you did is the recommended way of changing the profile values.
thanks
gopal
|||Many thanks for all.
"roll back" means, that i assigned my profile to distribution agent, but
next morning i saw "default" profile assigned to the same agent.
This issue now sorted out because i found MSagent_profiles,
MSagent_properties tables in msdb.
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!