Re: Dependencies in Enterprise Manager

From: Dan Guzman (guzmanda_at_nospam-online.sbcglobal.net)
Date: 11/06/04


Date: Sat, 6 Nov 2004 12:16:36 -0600


> can you build from your source code in seconds with no maintanence

Nope.

> is your database broken?

Nope.

-- 
Hope this helps.
Dan Guzman
SQL Server MVP
"mark baekdal" <markbaekdal@discussions.microsoft.com> wrote in message 
news:35826629-161C-4AC5-BB22-1EAB02D94AF5@microsoft.com...
> 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
>>


Relevant Pages

  • Re: Configuration of Login and password in VB6 program
    ... I have a VB6 project which the program needs to access SQL Server 2005 ... the userID is QA and the password is qapl. ... able to prevent the designer to have idea of login and password ... they should probably still have the source code ...
    (microsoft.public.vb.general.discussion)
  • Re: Name change, cant find origin of error
    ... You could run SQL Profiler to trace all queries sent to SQL Server when you perform this action through web app. ... There could be ad-hoc queries, views, UDFs, stored procs that may refer to the old table, you could take a look at the source code for those SPs, UDFs. ...
    (microsoft.public.sqlserver.tools)
  • Re: Edit System Stored Procedure, i.e. sp_helpdb
    ... It is not supported by MS to change the source code in SQL Server. ... "NRS" wrote in message ... I have one call from one application to that stored procedure ...
    (microsoft.public.sqlserver.server)
  • Re: Integration between VSS and SQL Server
    ... I tried to use isqlw.exe like you suggested but when it opens a SP it ... >> I'm trying to integrate VSS and SQL Server through VID. ... > add your source code to version-control that way. ... > through a keypress in the editor. ...
    (microsoft.public.vstudio.sourcesafe)
  • Re: Return Key (identity) on INSERT operation (SQL/ASP)
    ... hopefully he can expedite processing your full subscription. ... SQL Server MVP ... Columnist, SQL Server Professional ... Please reply to the newsgroup. ...
    (microsoft.public.inetserver.asp.general)