Transation Replication won't hold permissions

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

We replicate a portion of our data to another server to support our
website. This has been ongoing for several years and the data is
maintained on a two year cycle. Every two years the entire process is
torn down and rebuilt usually without a great many problems.

This year when the subscriber database is created using the "Yes,
initialize the schema and data" selection on the Initialize
Subscription screen, the tables that are created do not hold the
permissions that are assigned. However if I do not use this process
initially the stored proceedures are not created in the subscription
database to insert, update, delete, etc. I have been creating the
database then deleting all the tables and replication publication; then
scripting them with the permissions and restarting the publication with
the "No, Subscriber already has schema and data" option. This is
tedious and prone to error.

Anyone know why the first process will not hold permissions after
working well for so many years. Our only change is the live data is now
on a clustered server.

Bob

.

Relevant Pages

  • Re: Check Sysobjects Error during Snapshot
    ... Looking for a SQL Server replication book? ... > published databases, each publication is slightly different (row ... > A2 to subscriber 2 without a problem. ... I can replicate database b publication B2 to Subscriber2 without a ...
    (microsoft.public.sqlserver.replication)
  • RE: sp_MSgetreplicainfo(?,?,?,?,?,?)
    ... 14010 The remote server is not defined as a subscription server when ... connect subscriber server (through advanced entry in Client Network ... For more information about how to replicate between SQL Servers via Internet ...
    (microsoft.public.sqlserver.replication)
  • Re: Public Folder Security/Sharing
    ... In Exchange System Manager on the server, can you change the owner of the ... PFto include your admin account and replicated the change down to all of ... Then you can modify the permissions and replicate again. ...
    (microsoft.public.exchange2000.active.directory.integration)
  • Re: 3 Months - 3 Years.
    ... data which is older than 3 months) in a stored procedure and replicate ... procedure is a no-op on the subscriber. ... server and three years on the DSS box without concerns of data beind deleted ... month server and it will replicate over to the 3 year server. ...
    (microsoft.public.sqlserver.replication)
  • Re: [SLE] Directory structure replication
    ... > I need to replicate the whole directory structure (including ... > permissions, specially permissions) for a volume from one server to ... > and I need to replicate this whole structure (with permissions to a new ...
    (SuSE)