>You can do this...
>
>WITH (NOLOCK, INDEX (MyIndex))
>
>I'm not sure I'd advise using this approach in production - more of a design issue than anything else. But I think that syntax will work.
Yes, I found that a few minutes ago. Are you saying NOLOCK should not be used at all in a select statement?