Re: Trans Replication with all types of objects published

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Hassan (fatima_ja_at_hotmail.com)
Date: 02/23/05 

Date: Wed, 23 Feb 2005 14:55:21 -0800

So why doesnt MS kinda publish it anywhere especially with replication ,
that if we intend to replicate views,indexed views, it is best to create
seperate publications and also ensure that the publications that holds the
tables get pushed out successfully first to all the subscribers and then
start replicating the publication that holds views,etc

"Paul Ibison" <Paul.Ibison@Pygmalion.Com> wrote in message
news:ueGOaudGFHA.2136@TK2MSFTNGP14.phx.gbl...
> Hassan,
> there's no magic switch to fix this dependency issue:
> BUG: Recreating a Table Causes sysdepends to Become Invalid
> http://support.microsoft.com/?id=115333
> BUG: Reference to Deferred Object in Stored Procedure Will Not Show in
> Sp_depends http://support.microsoft.com/?id=201846
> sp_depends - Don't stake your project maintenance on it!:
> http://home.comcast.net/~b.wunder/16509.htm
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
>
>
>

Relevant Pages

  • Re: Turned off Replication and still receive this error....
    ... No...this is replication between two SQL2005 servers. ... Once the subscription and publications were deleted, ... Looking for a SQL Server replication book? ... I dropped the subscriptions and publications of this database, ...
    (microsoft.public.sqlserver.replication)
  • Re: Wipe and recreate Merge Pubs
    ... To run a validation expand replication, local publications, right click on ... Looking for a SQL Server replication book? ... do a no-sync with all subscribers. ... agents until they stop, and then run validations. ...
    (microsoft.public.sqlserver.replication)
  • Re: Repl Topology
    ... > REPLICATION clause when creating the tables. ... > Another thing about NOT FOR REPLICATION clause mentioned earlier. ... > Most of my publications are merge publications. ... > thread I started - Merge replication and dynamic filters. ...
    (microsoft.public.sqlserver.replication)
  • Re: Migration replication jobs
    ... You will be unable to detach replicated databases. ... then drop the publications, unpublish the databases and detach them. ... them on the new server, run the publication script and do a non sync. ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)
  • Help with replication design
    ... reporting server. ... New tables are OFTEN added to replication. ... I want a solution that is scaleable to up to 5 databases with the same ... Or is it better for me to create fewer, larger publications that are ...
    (microsoft.public.sqlserver.replication)