• This question is quite wrong. The SET key word can not be used by = (EqualTo operator). The correct syntax is:

    SET ANSI_NULLS OFF

    this is wrong:

    SET ANSI_NULLS= OFF

    Deepak Kumar Sharma