Post reply

Generate SQL script problem

  • September 7, 2005 at 1:11 pm

    #588232

    Sushila,  This may not apply to your problem of missing depenancies in views because I don't think you can create a view "View1" that references another view ("view2") if "view2" doesn't already exist .... 

    But ......

    If you create one Stored Proc  "SP1" that calls "SP2", but "SP2" doesn't exist yet, SQL will allow you to create "SP1" anyway, but you'll get a warning that it couldn't update the sysdepends system table. So later, when both "SP1" & "SP2" exist, SQL will not get the dependancy information right when you attempt to script them out.

  • September 7, 2005 at 1:19 pm

    #588234

    thx. homebrew01 - however I too think the deferred names are only for stored procedures...have to "play around" with this sometime to get to the bottom of it!!!







    **ASCII stupid question, get a stupid ANSI !!!**

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply