[dba-SQLServer] Warning, the table

John W. Colby jwcolby at colbyconsulting.com
Mon Oct 11 06:45:21 CDT 2004


Well, I kinda knew the answer to that one question.  How bout the others?  I
already went through this when I added an autonumber index.  It rebuilt the
table then, why is it doing it again?  This table is huge and rebuilding it
is a 48 hour process.  Do I have to go through this every time I add a field
to the table?  This is a bit ignorant don't ya think?

John W. Colby
www.ColbyConsulting.com 

Contribute your unused CPU cycles to a good cause:
http://folding.stanford.edu/

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Haslett,
Andrew
Sent: Sunday, October 10, 2004 11:39 PM
To: 'dba-sqlserver at databaseadvisors.com'
Subject: RE: [dba-SQLServer] Warning, the table


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.
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com







More information about the dba-SQLServer mailing list