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)
 sp_adddistributiondb and @Security_Mode

Author  Topic 

DBADave
Constraint Violating Yak Guru

366 Posts

Posted - 2004-02-13 : 15:55:47
If I specify @Security_mode = 1 when running sp_adddistributiondb, does this mean the distribution database will run SQL scripts such as instdist.sql under the security context of the SQL Server service account?

Dave
   

- Advertisement -