Post reply

Change Table property

  • July 10, 2003 at 10:25 am

    #65610

    Is the any way I can change the table created with set ansi_null off to set ansi_null on without droping and recrating?

    WE just start using indexed view.

    Thanks

  • July 11, 2003 at 7:53 am

    #465066

    SET ANSI_NULLS is a database option and you could set it on or off at anytime. Use sp_dboption or (as advised by microsoft) use ALTER DATABASE command. You could also use the SET command as part of your script for creating your indexed view.

    Hope this helps.


    Joseph

  • July 11, 2003 at 8:18 am

    #465088

    SET ANSI_NULLS Can be defined at there levels, for that mater any SET commands 1) Server 2) Database (Overwrites the server settings) 3) Session (Overwrites the Server and Database Settings).

    Shas3

  • July 11, 2003 at 12:22 pm

    #465141

    Thanks for help.

Viewing 4 posts - 1 through 3 (of 3 total)

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