Confused and Befungled --- HELP please

  • Hey all ,,, I have a very odd problem I cant seem to figure out. Here at work we have a stored procedure which when called processes data by calling other stored procedures.

    This stored procedure has been in place for some time and has been working just fine, recently we went over to new sql servers and have been having a few issues. The most recent one has me stumped.

    The main stored procedure the calls the other stored procedures fails every time it is executed unless i include a print statement. If i put a simple print 'here' statement ahead of a particular block the stored procedure runs fine. I take out the print, it crashes. Yet the print statement is doing nothing useful .

    Anyone hear of this before, or is my sql box possesed ,,, do I need a priest ....arggg.

    Please respond to rbrow112@ford.com if you have any input into this.

    Thanks

     


    Rick Brown

  • What does "crashes" mean? Are you getting an error? Did you remember to update the new server to the latest service pack?

    --
    Adam Machanic
    whoisactive

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

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