Re: Dependencies in Enterprise Manager

From: mark baekdal (markbaekdal_at_discussions.microsoft.com)
Date: 11/06/04 

Date: Sat, 6 Nov 2004 06:40:01 -0800

can you build from your source code in seconds with no maintanence, is your
database broken?

"Dan Guzman" wrote:

> I agree that SQL Server dependency management leaves much to be desired but
> a sanity check is in order here. If you rename an executable (e.g.
> MyApp.exe to MyNewApp.exe), do you expect you source code to automagically
> get updated to reflect the change? If you rename a function or variable
> name in your application program, do you expect existing references to be
> changed as well?
>
> IMO, SQL Server database objects should be treated similarly to other
> application code. We keep DDL under source control so that these scripts
> can be used as the master copy to promote database changes.
>
> --
> Hope this helps.
>
> Dan Guzman
> SQL Server MVP
>
> "DW" <None> wrote in message news:%23AOmYr4wEHA.4040@TK2MSFTNGP11.phx.gbl...
> >I have seen several cautions like "don't depend on 'Display
> > Dependencies' in Enterprise Manager; it's not reliable".
> >
> > I have seen evidence of this in SQL 2000 -- if you rename a view, the
> > associated 'text' field in the syscomments table is not changed to
> > reflect the rename. Which makes the text field in syscomments pretty
> > useless. And I think there are other causes that make 'Display
> > 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. SQL is a
> > database; why can't it keep actual track of dependencies?
> >
> > And why can't I rename a table, or a view, or a field in a table, and
> > have all the dependent views automatically udpated to reflect the
> > rename? It seems that an enterprise-class database and its tools ought
> > to be able to do this with no sweat.
> >
> > Is sp-depends any different than the dependencies in Enterprise Manager,
> > or are they the same thing?
> >
> > Is there really no reliable way to find out, for example, what views or
> > stored procedures in my database use field X from table Y?
> >
> > Thanks.
> >
> > David Walker
>
>
>

Relevant Pages

  • Re: How do rename a database
    ... When I tried to rename a database, ... The database could not be exclusively locked to perform the operation. ... Bing ... "Dan Guzman" wrote: ...
    (microsoft.public.sqlserver.server)
  • Re: What so special about PostgreSQL and other RDBMS?
    ... Unsubstantiated bunk, if you have the source code, it is not magic to ... my comments where ment *FOR DEVELOPERS* that is those who ... Oracle suits your needs and you think it's worth the money, use it, ... your database server, then write some additional functions as wrappers ...
    (comp.lang.php)
  • Re: Change Field Name in Table
    ... try to figure out the delete and/or renaming it again. ... table with the make Table query or even using the DoCmd Copy. ... move everything over to another database and use the new database. ... was Imported and you should be able to rename it. ...
    (microsoft.public.access.formscoding)
  • Re: WorkFlow / Process Design Pattern
    ... Take a look at Microsoft Patterns & Practices site, ... distributed as source code. ... memory, issolated storage, or a database, ... Configuration Management. ...
    (comp.object)
  • Re: In answer to RW - again (was: Sorts (revised)
    ... > The interaction between compiler and database would be defined by an external ... Which _particular_ parts that are not currently 'source code portable' ... what is non-portable now that this interract would change ... Cobol had 'ENTER language' in the ...
    (comp.lang.cobol)