Post reply

How to Avoid message "The command(s) completed successfully."

  • December 24, 2004 at 3:14 am

    #60280

    Hi,

    Could anyone tell me how we can avoid the message

    "The command(s) completed successfully." in SQL query analyser.  I tried checking the option "Discard results" in query Analyser. But it discards the result of queries also.

    I need to suppress server message since one of my SQL Script expects either NULL value or some valid value from the server. Therefore when the server message comes, the program gives error as the returned value is not proper.

    I know that We can suppress the count property by setting the NOcount to on. But can we also suppress the message "The command(s) completed successfully." in a similar way ?

     

    Thanks,

    Anoop

  • December 24, 2004 at 9:05 am

    #534984

    The command "The command(s) completed successfully" is being generated from Query Analyzer and not from SQL Server. I'm not sure what issue you are having but if you type in the same command from osql, you won't get any simillar text. Hope this helps.

  • December 29, 2004 at 8:28 am

    #535272

    Hi,

    Thanks for your kind help. I was trying to find out the reason for the wrong result my program was fetching & somebody told me that this could be the reason.

    Thank you once again.

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

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