No announcements
Found 1719233 threads
-
0 VotesShow Custom Error for Primary Key Violations
You should be able to do this in the data service's SaveChanges_ExecuteFailed method: Private Sub SaveChanges_ExecuteFailed(exception As Exception) 'do ...Answered | 1 Replies | 1656 Views | Created by New User Display Name - Wednesday, January 23, 2013 3:00 AM | Last reply by Yann Duran - Thursday, January 24, 2013 2:55 AM
-
3 Votes
Violation of primary key constraint error
Hi, I ensure that there is no other primary key .But still the same error comes.Once I make Identity specificatio OFF and ON ,And then insert,It will ...Answered | 4 Replies | 2031 Views | Created by manojkumar09 - Monday, September 23, 2013 7:33 AM | Last reply by pituach - Thursday, November 7, 2013 8:34 AM -
0 Votes
primary key violation errors
As said above you can eliminate the primary key violation using the merge statement like in the following example: create procedure [dbo].Answered | 15 Replies | 4196 Views | Created by neophytenik - Tuesday, July 13, 2010 7:58 PM | Last reply by Gert-Jan Strik - Wednesday, July 14, 2010 5:45 PM -
1 Votes
Primary Key Violation
IDENTITY and Primary Key are not the same.Answered | 3 Replies | 4955 Views | Created by DBA_KevyKev - Saturday, November 14, 2009 10:33 PM | Last reply by DogTog - Sunday, November 15, 2009 1:19 AM -
5 Votes
primary key violation issue in database
You have some serious issue than Primary Key violation.Answered | 6 Replies | 1730 Views | Created by '''HuuM''' - Tuesday, October 15, 2013 7:05 PM | Last reply by '''HuuM''' - Wednesday, October 16, 2013 3:22 PM -
0 Votes
Primary Key Violation in SSISDB.internal.execution_parameter_values
Not sure if you can just go and remove the violating entry, it is best to engage Microsoft Pro services in my view.Answered | 2 Replies | 960 Views | Created by liveMinimal - Tuesday, October 4, 2016 5:33 PM | Last reply by liveMinimal - Tuesday, October 4, 2016 6:15 PM -
0 Votes
with the transaction primary key violation error
Error handling in SQL Server is a very messy story.Answered | 11 Replies | 5716 Views | Created by Tharindu Dhaneenja - Wednesday, October 6, 2010 11:07 AM | Last reply by Tharindu Dhaneenja - Thursday, October 7, 2010 4:22 AM -
0 Votes
SSIS Upsert Primary Key Violation error
Now, in the lookup transform I was selecting the entire destination database table and I just changed it to select a specific colum(primary key column) instead of the entire table and the job ...Answered | 4 Replies | 2049 Views | Created by oleolehoohoo - Wednesday, April 2, 2014 3:04 PM | Last reply by Kalman Toth - Wednesday, April 2, 2014 4:47 PM -
0 Votes
got error on sql inserting - Violation of PRIMARY KEY
A table can have only one PRIMARY KEY constraint, and a column that participates in the PRIMARY KEY constraint cannot accept null values.Answered | 4 Replies | 4369 Views | Created by E_gold - Sunday, March 10, 2013 7:58 AM | Last reply by Jackson_1990 - Sunday, March 10, 2013 10:05 AM -
1 Votes
Description: "Violation of PRIMARY KEY constraint
It is clearly a Primary Key violation error, which would occur if source data has duplicate value(s) for the destination primary key of the table ...Answered | 6 Replies | 6735 Views | Created by thinkingeye - Monday, August 13, 2012 2:07 PM | Last reply by thinkingeye - Wednesday, September 12, 2012 2:14 PM -
0 Votes
Primary key violation error in sql server 2008
So the locking and concurrency will be managed by the database engine itself...If you need an incremental column as PRIMARY KEY, then change the ID column having an IDENTITY ...Answered | 5 Replies | 2167 Views | Created by irappabisanakoppa - Monday, March 25, 2013 5:07 AM | Last reply by Erland Sommarskog - Monday, March 25, 2013 7:52 AM -
0 Votes
Primary Key violation for no rhyme or reason
as Paul said,it must have been reseed to some existing value which was violating primary key constraint.Answered | 4 Replies | 3908 Views | Created by profnachos - Thursday, April 22, 2010 11:08 AM | Last reply by Hunchback - Thursday, April 22, 2010 1:39 PM -
0 Votes
Violation of PRIMARY KEY constraint
Don't use the primary key columns in the SELECT list, assuming that ID is your PRIMARY KEY and an IDENTITY: INSERT INTO ...Answered | 6 Replies | 3041 Views | Created by mkerr - Wednesday, November 2, 2011 11:57 AM | Last reply by Stefan Hoffmann - Wednesday, November 2, 2011 12:35 PM -
0 Votes
Violation of PRIMARY KEY constraint on replication
To alleviate the PK violations — you'll want to identify the max identity value used in each publisher and subscribers currently allocated ...Answered | 1 Replies | 5659 Views | Created by Saburo - Thursday, February 16, 2012 8:03 AM | Last reply by Brandon Williams - Monday, February 20, 2012 2:35 AM -
1 Votes
"Violation of PRIMARY KEY"
I don't know your table design and the flat file content, so I can ony guess: The fat file already contains doublet data=severa rows with the same primary key for the destination data?Answered | 3 Replies | 3284 Views | Created by Sandip_ - Thursday, May 10, 2012 3:25 PM | Last reply by Olaf Helper - Friday, May 11, 2012 5:03 AM -
3 Votes
How to monitor primary key violations particular table?
You can create a Profiler/server-side trace that will report only on PK violation errors, using the Exception event in the Errors and Warnings group, and filtering ...Answered | 9 Replies | 5876 Views | Created by AianRi - Wednesday, November 14, 2012 6:12 PM | Last reply by Dattatray Nale - Sunday, November 18, 2012 3:44 PM -
0 Votes
how to track down primary key violation problem
The fields that I refer to is the values in the primary key column.Answered | 14 Replies | 6215 Views | Created by hkg04 - Thursday, November 1, 2012 7:59 PM | Last reply by hkg04 - Thursday, January 31, 2013 9:38 PM -
0 Votes
Primary Key rule Violation error while Insert Record in Compact DB
I suspect the reason is because you already have some data in student table but you identity seeds were not updated and hence it is trying to insert a row with emp_id value that ...Answered | 2 Replies | 2192 Views | Created by jainn - Friday, March 13, 2015 12:23 PM | Last reply by Stan210 - Friday, March 13, 2015 1:01 PM -
0 Votes
Handle Violation of Primary Key Constraint in SSIS
I am getting the following error when running an integration services project to insert and Update data from one sql ...Answered | 4 Replies | 16903 Views | Created by Bhushan W Juare - Friday, November 11, 2011 8:26 AM | Last reply by Eileen Zhao - Wednesday, November 16, 2011 8:54 AM -
2 Votes
violation of primary key constraint
Well, yes, if you write the stored procedure so that it does not get an error, then it won't cause XACT_ABORT to force a rollback.Answered | 9 Replies | 6263 Views | Created by neophytenik - Wednesday, August 4, 2010 6:34 PM | Last reply by Tom Cooper - Thursday, August 5, 2010 5:56 PM - Items 1 to 20 of 1719233 Next ›
No announcements
