No announcements
Found 1430180 threads
-
0 Votesprimary key not found
The error message is pretty clear.Answered | 2 Replies | 3261 Views | Created by richfp - Wednesday, December 19, 2012 7:47 PM | Last reply by MasaSam - Friday, December 21, 2012 6:44 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 ...Answered | 4 Replies | 2492 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
Show Custom Error for Primary Key Violations
I have a LightSwitch application that returns the following error to the client anytime there is a primary key violation: Unable to save ...Answered | 1 Replies | 1848 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 -
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 ...Answered | 5 Replies | 2369 Views | Created by irappabisanakoppa - Monday, March 25, 2013 5:07 AM | Last reply by Erland Sommarskog - Monday, March 25, 2013 7:52 AM -
3 Votes
Primary Key Design Practices
I also got this error trying to reply to you now.Answered | 18 Replies | 7983 Views | Created by Mercury529 - Friday, November 23, 2012 7:22 PM | Last reply by Naomi N - Monday, November 26, 2012 12:28 AM -
0 Votes
Is Primary Key automatically sorted?
Hi, To created sorted index (Clustered Index) the syntax like this CREATE CLUSTERED INDEX myIndex ON myTable ...Answered | 1 Replies | 8054 Views | Created by ray247ray - Sunday, June 10, 2012 1:04 AM | Last reply by Elmozamil Elamir - Sunday, June 10, 2012 8:19 AM -
0 Votes
Primary Key field size
Hello Naomi, Actually its an error message (cancelling the operation, rollback and returned the error message) and more than a warning right?Answered | 7 Replies | 1730 Views | Created by johnt757uv - Friday, June 13, 2014 7:33 PM | Last reply by johnt757uv - Tuesday, July 1, 2014 1:56 AM -
1 Votes
2 Primary Keys
Here is the simplified declarative syntax: create table Test_table( Col1 int identity(1,1) PRIMARY KEY, col2 int NOT NULL ...Answered | 10 Replies | 1615 Views | Created by Debra has a question - Friday, March 14, 2014 4:50 PM | Last reply by davidbaxterbrowne - Saturday, March 15, 2014 12:31 AM -
0 Votes
primary and foreign key constraints
I am working to add each of the tables to the database, with their primary and foreign keys where I believe they are applicable.Answered | 7 Replies | 8409 Views | Created by hfinny - Wednesday, May 5, 2010 11:20 PM | Last reply by Louis Davidson - Thursday, May 6, 2010 8:46 PM -
1 Votes
Does a foreign key have to be a primary key
It is unusual to see a foreign key that does not reference a primary key.Answered | 9 Replies | 2217 Views | Created by Divideby - Wednesday, July 30, 2014 10:43 AM | Last reply by Ahsan Kabir - Thursday, August 7, 2014 6:12 AM -
0 Votes
Table primary key and Replication
For transactional replication, all tables which needs to be published need to have a primary key.Answered | 2 Replies | 5910 Views | Created by LOSTCAUSE - Wednesday, June 22, 2011 2:05 PM | Last reply by Ashwin Menon - Thursday, June 23, 2011 3:00 AM -
2 Votes
Cluster index and primary key
By default SQL Server creates a clustered index when you create a PRIMARY KEY.Answered | 5 Replies | 9957 Views | Created by subu999 - Saturday, October 30, 2010 5:53 AM | Last reply by Uri Dimant - Monday, November 1, 2010 7:43 AM -
2 Votes
primary foreign key referencing
This means that a primary key can be a primary and a foreign key at the same time in the same table?Answered | 9 Replies | 9883 Views | Created by N.Afache - Friday, October 21, 2011 11:51 AM | Last reply by J Alverson - Sunday, October 30, 2011 7:32 AM -
0 Votes
Entity Framework - Primary Key and Foreign Key Namess
However EF doesn't support foreign keys that refer to unique indexes, and not the primary key.Answered | 1 Replies | 1695 Views | Created by Natron61 - Monday, December 30, 2013 3:35 PM | Last reply by davidbaxterbrowne - Monday, December 30, 2013 3:53 PM -
2 Votes
Using symbols in primary key
We think you need to improve the concept of Primary key What is a key, and why is one of them a primary key?Answered | 2 Replies | 2013 Views | Created by ogzgl - Saturday, July 25, 2015 8:35 AM | Last reply by Ahsan Kabir - Monday, August 3, 2015 4:02 AM -
0 Votes
Confusion on Natural Key Primary, vs Surrogate Key Primary
Isn't it true tho that a primary key is the main key on your table that all other indexes run off of?Answered | 9 Replies | 2444 Views | Created by Bloodofgods - Thursday, September 10, 2015 4:26 AM | Last reply by Soumen Barua - Friday, September 18, 2015 3:07 PM -
5 Votes
Primary key problem!!!
Below is a code example that will display a MsgBox with the duplicate key error message.Answered | 19 Replies | 2732 Views | Created by gautamshaw - Wednesday, August 5, 2009 8:13 AM | Last reply by Paul P Clement IV - Wednesday, August 5, 2009 3:36 PM -
2 Votes
Foreign key references a two column primary key
There is absolutely no workaround to have a foreign key with one column referencing to a primary key of two columns?Answered | 13 Replies | 22116 Views | Created by pyram07 - Thursday, June 14, 2012 1:17 PM | Last reply by pyram07 - Thursday, June 14, 2012 6:18 PM -
1 Votes
About primary key in the table?
depends on the primary key constraints you have set.Answered | 1 Replies | 4123 Views | Created by Mitkram - Saturday, October 24, 2009 6:45 AM | Last reply by Jeff - www.SRSoft.us - Saturday, October 24, 2009 1:56 PM -
1 Votes
Difference between Primary key with clustered index and primary key with nonclustered index.
The main difference between a Primary key and a Unique Key that a Unique key will allow a null value (albeit only one) whereas a Primary Key ...Answered | 5 Replies | 20710 Views | Created by SathyJay - Friday, July 19, 2013 11:14 AM | Last reply by Anthony C-UK - Friday, June 26, 2015 2:30 PM
No announcements
