Results 1 to 3 of 3

Thread: sp_recompile

  1. #1
    Join Date
    Oct 2003
    Location
    Singapore
    Posts
    4

    Angry Unanswered: sp_recompile

    Hi,
    sp_recompile doesn't seem to make a previously-compiled stored proc return a column that was added subsequently.

    Does anyone know any alternative to dropping & re-creating the stored proc? What about stored procs in other database instances?

    Thanks for any suggestions!

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780

    Re: sp_recompile

    Originally posted by sun_zi_88
    Hi,
    sp_recompile doesn't seem to make a previously-compiled stored proc return a column that was added subsequently.

    Does anyone know any alternative to dropping & re-creating the stored proc? What about stored procs in other database instances?

    Thanks for any suggestions!
    Hi,

    You checked the object with sp_depend.

    Gustavo.

  3. #3
    Join Date
    Oct 2003
    Location
    Singapore
    Posts
    4
    Finding out the dependencies within the same database is part 1, part 2 is find out the dependencies across databases within the same server. Part 3 is find out across different servers. Finally, part 4 is getting those dependent objects to recognize the new column.

    Any suggestions (especially for part 4)?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •