Re: Replication - Views/SPs etc

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

From: Paul Ibison (Paul.Ibison_at_Pygmalion.Com)
Date: 05/03/04 

Date: Mon, 3 May 2004 13:29:15 +0100

Tim,
the problem you have with the views is one of dependencies. Using sp_depends
on a nesting view you can see which views SQL Server thinks it depends on
and this is not always correct. You can use sp_refreshview to update the
dependencies then replication will add the views in the correct order.
HTH,
Paul Ibison

Relevant Pages

  • Re: services failing on reboot
    ... You need to determine the dependencies of each service and ensure that they ... start in the correct order. ... This kb will tell you how to delay a service ... After the server is fully up they will start manually. ...
    (microsoft.public.win2000.active_directory)
  • Re: view cannot be replicated because another view it depends on does not yet exist
    ... you can use sp_refreshview to refresh the dependencies, so SQL Server ... replication will apply them in the correct order. ...
    (microsoft.public.sqlserver.replication)
  • Re: Who is using MSMQ?
    ... I understand about the dependencies; ... the SQL Server Service Manager are the same ones you get from the Windows ... about MSMQ and MSMQTriggers? ...
    (microsoft.public.sqlserver.security)
  • Re: Import / Ordering / Script File
    ... Basically SQL Server doesn't handle dependencies as it cannot due to the ... Database change management for SQL Server ... >> I am not sure why you are scripting and creating views in a DTS job? ...
    (microsoft.public.sqlserver.programming)
  • Re: Dependencies in Enterprise Manager
    ... If you rename an executable (e.g. ... SQL Server database objects should be treated similarly to other ... > Dependencies' can give the wrong answers, but I don't remember them all. ... > All of this seems to be a HUGE hole in Enterprise Manager. ...
    (microsoft.public.sqlserver.programming)