Results 1 to 1 of 1
  1. #1
    Join Date
    Jun 2002
    Posts
    1

    Question Unanswered: why does column length change force ANSI_NULLS on?

    I tried to change the length of a field in a SQL Server table using Enterprise Manager (SQL2000), but when I try to save the table I get this Validation Warning:
    --------------------------------------
    'zValueLists' table
    - Warning: The table was created with ANSI_NULLS 'off' and will be re-created with ANSI_NULLS 'on'.
    --------------------------------------
    The database has ANSI_NULLS off, and I want it to stay that way.
    The table was created by upsizing it from Access.

    Does anyone know why it's trying to change it to 'on'?

    Thanks,
    Jo.
    Last edited by jmaidment; 06-19-02 at 13:37.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •