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