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

    Unanswered: Hiding Sybase warning message

    Hi,

    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
    Location
    Prague
    Posts
    17
    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
  •