The table in SQL Server has a unique index on a field. When I attempt to add a record with a duplicate value in this field, the SP correctly does not save the record. However, in my form, it looks like the save succeeded and no failed save message occurs. When does the SP need to return so that I can give the user the proper feedback?

TIA