Post reply

Compiling stored procedures

  • October 25, 2007 at 1:33 pm

    #176600

    Is there a way in 2005 to force invalid object resolution when compiling and recompiling stored procedures?

  • October 25, 2007 at 9:14 pm

    #745550

    SQL Server only compiles/recompiles stored procedures during their execution. Therefore, it needs to be able to resolve the objects at that time. Or I may be completely misunderstanding your question. If so, can you indicate more about what you're trying to do?

    K. Brian Kelley
    @kbriankelley

  • October 25, 2007 at 9:58 pm

    #745558

    Is the issue that when you create a stored procedure one of more of the objects it depend on does not exist yet ?

    As far as I know, this is a feature of SQL that you cannot turn off.

  • October 26, 2007 at 6:00 am

    #745660

    It's when we create a proc.

Viewing 4 posts - 1 through 3 (of 3 total)

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