Re: Replication - Views/SPs etc

From: Michael Hotek (mhotek_at_nomail.com)
Date: 05/03/04 

Date: Mon, 3 May 2004 12:51:59 -0400

It should be, but you do have the potential to create circular views and
replication can not sort that out. There are also issues when dealing with
complex dependency chains. The best solution to this is to literally do it
yourself via a pre-script. You are the only one who knows what the precise
creation order needs to be, I would not leave it to an auto generated
process. 

-- 
Mike
Principal Mentor
Solid Quality Learning
"More than just Training"
SQL Server MVP
http://www.solidqualitylearning.com
http://www.mssqlserver.com

Relevant Pages

  • Re: Overcoming Transact-SQL ORDER BY limitations
    ... That's a good point, dealing with NULL's. ... that suggests not using this suggestion, ... a variation to examine the impact of dealing with NULL's. ... I could use a calculated field and sort on ...
    (microsoft.public.sqlserver.programming)
  • Re: Corruption on re-replicating a db
    ... Perhaps the relationships are circular and cannot be resolved by Jet ... metadata about the back end that has been invalidated in the process ... of recreating the replica. ...
    (microsoft.public.access.replication)
  • Re: Corruption on re-replicating a db
    ... Perhaps the relationships are circular and cannot be resolved by Jet ... metadata about the back end that has been invalidated in the process ... of recreating the replica. ...
    (microsoft.public.access.replication)
  • Re: Copying Active directory?
    ... Server 2005 R2 have any sort of trial period? ... Recovery solution, so I have to have something that is rock solid. ... the initial replication could take a while depending on your WAN links and the amount of data that needs to be replicated but it will sync up for you eventually. ...
    (microsoft.public.win2000.active_directory)
  • Re: OT - Dont shop Country Door.com
    ... dealing with Jack at AFN is never a hassle. ... "ATC New England" it is easy to sort and throw directly into the trash. ...
    (rec.pyrotechnics)