Post reply

replication store procedures

  • October 24, 2005 at 9:48 am

    #102882

    Hi, 

    What I have is sql server 2000 sp3.  When I push the store procedures out with snapshot replication the store procedures get put on the subscriber just fine, but the permissions are lost.  So I have to run a job on each of the subscribers to add the permissions.  Is there anyway to include the permissions?  Does anyone have any ideas.

     

    Thanks

    Mark

  • October 27, 2005 at 8:00 am

    This was removed by the editor as SPAM

  • October 28, 2005 at 11:26 am

    #601017

    This is actually a feature of replication believe it or not !

    If you are using SQL 2000, in replication there is an option to apply scripts automatically pre-, or post-snapshot. I believe its a setting within the publication.

    Just state the scripts to be applied - in this case your permissions after the snapshot.

    Paul R Williams.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply