October 26, 2004 at 10:01 am
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
October 26, 2004 at 10:04 am
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