Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2010

    Unanswered: Hiding Sybase warning message


    I have a set of queries getting fired from shell scripts which then emails the result in xl file. As I am forcing indexes on the tables any warning message are also included in the xl file.

    How to get rid of this message.

    set nocount on does not work for message.

    Message ex :
    "Index '1' specified as optimizer hint in the FROM clause of table 'kplus..ForwardDeals' does not exist. Optimizer will choose another index instead."

  2. #2
    Join Date
    Feb 2009
    Hi, I'm aware that I'm not answering your question, but do I understand it right that you are forcing nonexistent index and you want to hide the message reporting that this index does not exist?

Posting Permissions

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