No announcements
Found 2348692 threads
-
0 VotesTableAdapter referential integrity error on MDB database
you make a change triggering the referential integrity error. My problem was that my changes to the MDB in the BIN directory were getting overwritten by ...Answered | 2 Replies | 3113 Views | Created by j-c-m - Wednesday, July 25, 2012 12:05 AM | Last reply by j-c-m - Wednesday, July 25, 2012 3:46 PM
-
1 Votes
Cross-database referential Integrity
I would probably use a single database with separate schemas for this. The only way you get constraint based referential integrity is to have a single ...Answered | 2 Replies | 10567 Views | Created by [Marcos] - Sunday, July 11, 2010 4:48 PM | Last reply by SandeepM_ - Tuesday, July 13, 2010 7:25 AM -
0 Votes
Referential Integrity
the link of that product to its previous transactions. So, I tried to edit the relationship of the tables to enforce referential integrity with cascading edits, but I keep ...Answered | 3 Replies | 607 Views | Created by JonathonH - Wednesday, May 21, 2014 7:41 PM | Last reply by .theDBguy - Wednesday, May 21, 2014 8:05 PM -
0 Votes
Not reporting referential integrity error
have referential integrity issue in the underlying database. I have checked the error configuration of both the measure groups and in both the ... -
0 Votes
Referential Integrity with ADOX
fine, yet I can't find how to set (and determine) the referential integrity property of the relationships, which is visible in Access ... -
0 Votes
Check on referential integrity
kind of violations of referential integrity, report on them, and even repair them to a far extent. My question is: What has Access to offer in this ...Answered | 4 Replies | 128 Views | Created by Imb-hb - Monday, January 15, 2018 1:48 PM | Last reply by Imb-hb - Tuesday, January 16, 2018 9:12 AM -
0 Votes
Issue with referential integrity on subscriber database
. I do have referential integrity on the suscriber database, however I have had to mark it not for replication in order to allow the replication ...Answered | 6 Replies | 5507 Views | Created by DDroog - Friday, February 29, 2008 3:54 AM | Last reply by DDroog - Tuesday, March 18, 2008 5:31 AM -
4 Votes
referential integrity
Like i just mentioned i made it work using a update and delete trigger function which i found difficult to write. It would have been so neat to make it work using ...Answered | 4 Replies | 7784 Views | Created by Prinzxxx - Sunday, July 4, 2010 8:04 AM | Last reply by Uri Dimant - Sunday, July 4, 2010 2:27 PM -
0 Votes
Defer referential integrity constraint
Hello, Is there any way in SQL Server 2005 (SP2) to defer the referential integrity constraints until -
0 Votes
referential integrity constraint violation occurred
. I am using Entity framework 5.0 dbcontext with database first When I add new SalesOrder it works fine but when edit existing Salesorder i ...Answered | 2 Replies | 3351 Views | Created by Vinay Suryawomshi - Sunday, November 18, 2012 6:02 AM | Last reply by Alexander Sun - Monday, November 19, 2012 1:43 AM -
0 Votes
Referential Integrity question
I have a question regarding referential integrity after looking at a collegues database diagram. I noticed that a relationship exists between 2 tables, ...Answered | 6 Replies | 2877 Views | Created by spark29er - Tuesday, July 2, 2013 5:21 PM | Last reply by J Alverson - Tuesday, July 2, 2013 10:11 PM -
0 Votes
partitioning and referential integrity
table's origional primary key combined with the datetime column the new primary key which will result in my second table's referential integrity to be broken.My second table also ... -
0 Votes
Referential Integrity Constraints w/o Referential Integrity in the db?
The problem that I have is that we are working with a highly denormalized database so true constraints on all of our tables are not really an option at the ...Unanswered | 2 Replies | 5306 Views | Created by mthornto - Friday, March 16, 2007 10:12 PM | Last reply by mthornto - Monday, March 19, 2007 1:59 PM -
1 Votes
SQLBulkCopy and Referential Integrity
I was testing the SqlBulkCopy object today and found that it gets past Sql Servers enforcement of referential integrity.Unanswered | 1 Replies | 7156 Views | Created by rangermac - Wednesday, December 10, 2008 8:57 PM | Last reply by James Hugard - Tuesday, July 28, 2009 9:33 PM -
0 Votes
Spork Error - Referential Integrity Issue
I was trying out the Spork sample on the Jan CTP Refresh of the Oslo SDK, and on step two, running C:\Spork\Models\install.cmd and I get this ...Answered | 1 Replies | 4484 Views | Created by Ben Cline1 - Wednesday, March 25, 2009 2:08 AM | Last reply by Ben Cline1 - Wednesday, March 25, 2009 2:48 AM -
0 Votes
Referential Integrity Constraints w/o Referential Integrity in the db?
Using the new referential integrity constraints that will be made available, will it allow us to manually define the relationships between entities even if there is no true foreign ...Answered | 4 Replies | 5961 Views | Created by mthornto - Monday, March 19, 2007 2:06 PM | Last reply by Colin Meek - Microsoft - Tuesday, March 20, 2007 2:07 PM -
0 Votes
Referential integrity across databases
Hello. I have a database application containing shared data and client-specific data. The client data is identical in architecture but different in content. I'd like to enforce ...Answered | 5 Replies | 4368 Views | Created by DarrellDoesData - Friday, September 4, 2009 8:38 PM | Last reply by DarrellDoesData - Saturday, September 5, 2009 10:24 PM -
0 Votes
Referential integrity issues
I edited the referential integrity in my DB (....after i inserted records...) and i chose Cascade as the rule specified...well, it sent me aAnswered | 2 Replies | 3231 Views | Created by Victor BA - Tuesday, May 15, 2007 12:11 AM | Last reply by AndyKr - Tuesday, May 15, 2007 10:50 AM -
0 Votes
Cross Row Referential Integrity
In SS05 XML typed columns, is it possible to have cross row constraints and referential integrity? Say I have a column with two schemas: Author and Book. Each has ...Answered | 4 Replies | 8832 Views | Created by Hemant K - Thursday, February 23, 2006 4:36 PM | Last reply by Hemant K - Monday, February 27, 2006 4:19 PM -
3 Votes
tabel issue / key /referential integrity
attribute in the Transport table. A Transport could then be entered without a Party, and referential integrity is still enforced. Integrity only prevents entering ...Answered | 9 Replies | 389 Views | Created by tekoko10 - Saturday, May 7, 2016 3:37 PM | Last reply by Imb-hb - Tuesday, May 10, 2016 4:26 PM - Items 1 to 20 of 2348692 Next ›
No announcements
