First off I do not know if this belongs in SQL or here but I will try here. <BR><BR><BR>I created a table with constraints to stop someone from not entering a valid email address. However fire it off from a ASP page with a command object and it bypasses the constraints and inserts null even thou the field is specified as not null. And does not fire an error state back into the asp with the server.getlasterror returns .number = 0 and line = 0 everything else is a null string. <BR><BR>So my question would be what in hades is going wrong with the sp or asp transactions?<BR><BR>