Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Addl. question related to transactional repl publications

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-08-11 : 09:24:47
Normajean writes "Hi again;
I just submitted a question about 10 minutes ago, related to whether or not each table I'm replicating should be a single article in it's own publication. I forgot to ask a related question regarding replication security: Should distribution agents I create for each publication have their own separate windows login/pwd or share a common one between them?
Thanks!
Normajean Bowen"

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2006-08-19 : 13:47:04
agents as in jobs?

use sa to run the jobs, then you can define the SA account on the replication property window under the tools > replication > configure... for each of the subscriber

--------------------
keeping it simple...
Go to Top of Page
   

- Advertisement -