Post reply

SQL 2005 SP2 - ANSI NULL Default ON

  • March 16, 2007 at 9:15 am

    #117907

    Has anybody else encoutered a change in behavior with SP2 and its Hotfix changing the default for the Server Setting 'ANSI NULL Default ON'?

    On our QA server, after a database restore for testing purposes, the default was causing temp tables to be created with not allowing NULLs and before SP2, the restores were not doing this.

    Of course best practice would be to specify the Null when creating a table, temp table, etc. But trying to manage previous buit app.

     

    Thanks,

    Daniel

  • March 17, 2007 at 6:24 pm

    #695589

    Temp tables are actually created in TempDB. which gets generated from Model every time SQL Server is restarted. Since this is a database level setting, have you checked both TempDB and Model to see what their settings are?

     

    K. Brian Kelley
    @kbriankelley

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

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