I've got a stored procedure that uses a join hint like this: (nolock, index(BoundDateMod_Idx)) When I run it I get the following message: Warning: The join order has been enforced because a local join hint is used. Is there a way to turn this warning off? Assume that I want to keep the join hint. The reason I want to get rid of the warning is an ASP page that calls this stored procedure. I think ASP has ignored these warnings in the past, but now if I get a warning the page continues as though no rows were returned from the SP (even though rows were returned). The good thing is that the warning only appears the first time the stored procedure is run, so I can run it a second time and the ASP page will work. But if possible, I'd rather just turn off those warnings. I thought it could be done by adding this to the begining of my stored procedure: Set Ansi_Warnings OFF Adding that line doesn't get rid of my warning. Any ideas? Many thanks in advance for your help!