Re: Replication - Views/SPs etc

From: TimS (anonymous_at_discussions.microsoft.com)
Date: 05/03/04 

Date: Mon, 3 May 2004 08:11:29 -0700

Hi Paul,

Thanks! - this makes sense that this should be part of the
SQL Server tool-box.

Unfortunately I cannot find sp_refreshview to correct the
dependancy list - so that when scripting the views - these
are rebuilt fully - or maybe I just do not understand .....

If you could point me in the right direction!!

Thanks

Tim

>-----Original Message-----
>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: 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)
  • RE: Installing Service Pack on multiple instance cluster
    ... To install the service pack on a failover cluster ... - If any resources have been added with dependencies on SQL Server ...
    (microsoft.public.sqlserver.server)
  • Re: SP3a on cluster...help please
    ... dependent on the databases in that cluster need to be ... >tool that needs to live in the SQL virtual server. ... >I support the Professional Association for SQL Server ... >> Server Resources those dependencies must either before ...
    (microsoft.public.sqlserver.clustering)