Haslett, Andrew
andrew.haslett at ilc.gov.au
Sun Oct 10 22:39:06 CDT 2004
As with most things, probably better explained in BOL. It has to do with the default comparison of NULL's. Search BOL for ANSI_NULLS specifically the topic NULL COMPARISON SEARCH CONDITIONS -----Original Message----- From: John W. Colby [mailto:jwcolby at colbyconsulting.com] Sent: Saturday, 9 October 2004 1:21 AM To: SQLServer Subject: [dba-SQLServer] Warning, the table When I try to add a field to the table it gives me a "Warning, the table was created with Ansi Nulls OFF. The table will be recreated with Ansi Nulls ON". I know from experience that this causes the db to go off for days at a time rebuilding the table. What the <expletive deleted> are ansi nulls and why was the table created with it off? Why do I need them now? Is there any way to prevent this and yet still be able to add a field? Is there any way to allow setting ansi nulls on but not "rebuilding the table"? I already added a field (an int identity) and it told me it was rebuilding the table for that field. Why is it having to rebuild the table again. This is getting rather silly especially since it takes literally days to rebuild the table. John W. Colby www.ColbyConsulting.com Contribute your unused CPU cycles to a good cause: http://folding.stanford.edu/ _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com IMPORTANT - PLEASE READ ******************** This email and any files transmitted with it are confidential and may contain information protected by law from disclosure. If you have received this message in error, please notify the sender immediately and delete this email from your system. No warranty is given that this email or files, if attached to this email, are free from computer viruses or other defects. They are provided on the basis the user assumes all responsibility for loss, damage or consequence resulting directly or indirectly from their use, whether caused by the negligence of the sender or not.