October 8, 2007 at 2:06 pm
Comments posted to this topic are about the item Identify Primary Key Violation Prior to Insert (Updated)
Karen Gayda
MCP, MCSD, MCDBA
gaydaware.com
October 10, 2007 at 1:22 pm
For more detail on using this procedure, read the SQL Team article that I posted: http://www.sqlteam.com/article/anticipating-primary-key-violations
This gives step-by-step instructions on how to get the most out of this procedure.
Karen Gayda
MCP, MCSD, MCDBA
gaydaware.com
February 19, 2009 at 6:29 am
What ever happened to simply grouping by the primary key with a count > 1? Wouldn't that find dupes just as well? It seems like overkill to run each record through a cursor against multiple functions.
February 19, 2009 at 7:04 am
It doesn't work in every scenario. The proc. that I wrote handles every condition possible that I had encountered.
Karen Gayda
MCP, MCSD, MCDBA
gaydaware.com
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply