[dba-SQLServer]SQL Server default value not happening

John W. Colby jcolby at colbyconsulting.com
Thu Feb 27 06:40:43 CST 2003


I upsized my client billing to SQL Server the other day.  This morning I
noticed that a couple of flag fields in my main time table are not being set
to their default value.  I went directly into EM and created a record in the
table and the flags are correctly set there.  I opened the ADP, opened the
table there and entered a record, and the default value is NOT being set
correctly there.

Any ideas why the default values would work in EM but not in the ADP?

John W. Colby
Colby Consulting
www.ColbyConsulting.com

----------------------------------------------------
Is email taking over your day?  Manage your time with eMailBoss.
Try it free!  http://www.eMailBoss.com





More information about the dba-SQLServer mailing list