i'm reading sybex mcse: sql server 7 admin study guide, chapter 12, page 545. it states that the replication agents call xp_loginfo to verify that the sql server agent has the appropriate permissions on various servers.
it then states that the agent never actually starts running, so no error is logged. can't you start the sql server agent before the rep agents call that stored procedure? can't you re-write the xp_loginfo stored procedure so it triggers an alert to let you know what errors it has detected? if not, why?
tia,
t
bobbie
thibault@hotbot.com
it then states that the agent never actually starts running, so no error is logged. can't you start the sql server agent before the rep agents call that stored procedure? can't you re-write the xp_loginfo stored procedure so it triggers an alert to let you know what errors it has detected? if not, why?
tia,
t
bobbie
thibault@hotbot.com