Post reply

NOLOCK Hint Corrupts Results from SELECT

  • November 28, 2012 at 9:53 pm

    #1563557

    SQLKnowItAll (11/28/2012)

    mmartin1 (11/28/2012)

    It may not be a bad idea to have the server and other workstations check apply updates automatically to Windows and applications.

    Yes it would. This should administered by a systems or domain administrator.

    Thanks. We let Server Ops know 😉

  • November 28, 2012 at 9:55 pm

    #1563558

    TheSQLGuru (11/28/2012)

    Langston Montgomery (11/26/2012)

    Update:

    We upgraded the production server to SP1, and the issue is gone. Lunch for anyone who can figure out why it was happening 🙂

    Seems pretty obvious what was happening: you experienced the effects of a bug in the product that was fixed by the SQL Server patch you applied. End of story. Do I get a prize?? :hehe:

    Lol. You bet!

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply