I've got a website that will be using a SQL backend for dynamic data. The data needs to be replicated from specific tables in a master SQL database that resides in a different domain, along with a few stored procedures that allow access to the date.
I've managed to get the replication process to work (using transactional replication, no subscriber updating needed), but I can't seem to get user and role permissions to replicate for the stored procedures...i.e., the SPs replicate over okay but don't have any permissions granted to them. There's enough of them that I don't want to have to do it manually. All the database access is done through the SPs; I don't need table permissions to replicate over, just for the SPs. This is only a problem on the initial snapshot initialization; the transactional data updates are working fine. Any ideas? I thought I had it working once but can't seem to duplicate the setup. TIA, Tim ___________________________ Tim Furry Web Developer Foulston Siefkin LLP ____ � The WDVL Discussion List from WDVL.COM � ____ To Join wdvltalk, Send An Email To: mailto:wdvltalk-join@;lists.wdvl.com Send Your Posts To: [EMAIL PROTECTED] To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub ________________ http://www.wdvl.com _______________________ You are currently subscribed to wdvltalk as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
