I need help in how to troubleshoot this issue. I get this error when trying to do an insert.
Violation of PRIMARY KEY constraint 'pk_FieldName'. Cannot insert duplicate key in object 'SomeTable'. The field in question is the primary key and is an identity column set to auto-increment by 1. How can a table set to auto-increment violate a primary key? This is SQL Server 2005. I first got it in a CF page, but get the error even if running the query directly in a query window in SQL Server Management Studio. -- Matt Williams "It's the question that drives us." ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282747 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4