No announcements
Found 2716830 threads
-
7 VotesHow to check referential integrity
I am also importing data, and need to handle the situation if there are integrity errors in the data coming in.Answered | 17 Replies | 19204 Views | Created by ProIT-Mike - Thursday, October 7, 2010 11:49 AM | Last reply by Hunchback - Tuesday, October 12, 2010 5:03 PM
-
1 Votes
Cross-database referential Integrity
The only way you get constraint based referential integrity is to have a single database.Answered | 2 Replies | 10933 Views | Created by [Marcos] - Sunday, July 11, 2010 4:48 PM | Last reply by SandeepM_ - Tuesday, July 13, 2010 7:25 AM -
4 Votes
referential integrity
It would have been so neat to make it work using referential integrity.Answered | 4 Replies | 8037 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
Referential Integrity in multiple tables
But that does not replace checking for data integrity in the database, au contraire.Answered | 4 Replies | 962 Views | Created by HICRosa - Thursday, December 31, 2015 2:01 PM | Last reply by Erland Sommarskog - Friday, January 1, 2016 11:15 AM -
5 Votes
Referential integrity in SQL Server
Hi, Referential integrity is a system of rules that ensure relationships between rows in related tables are valid and that you do not accidentally delete or ...Answered | 5 Replies | 4132 Views | Created by recherche - Wednesday, April 23, 2014 3:24 AM | Last reply by Kalman Toth - Friday, April 25, 2014 10:16 AM -
4 Votes
Referential Integrity in a trigger for multiple rows
Would the following trigger work for a bulk insert IF EXISTS (select 1 from inserted I where not exists (select 1 from Customer cust where cust.Id = ...Answered | 6 Replies | 2373 Views | Created by system243trd - Tuesday, November 20, 2012 10:47 PM | Last reply by scott_morris-ga - Wednesday, November 21, 2012 2:29 PM -
0 Votes
Referential integrity, cascading delete and transactions
If you have more data, then you must partition it into disjoint sets using a partitioning scheme. azure.microsoft.com/en-us/documentation/articles/documentdb-partition-data has some tips on ...Answered | 2 Replies | 1708 Views | Created by howdy_doody - Friday, June 26, 2015 4:04 PM | Last reply by howdy_doody - Monday, June 29, 2015 4:33 PM -
2 Votes
DRI (declarative referential integrity) and speed improvements.
https://connect.microsoft.com/SQLServer/feedback/details/683411/dri-referential-integrity-does-not-optimize-if-compound-key-is-used-for-the-key-relation ...Answered | 7 Replies | 7338 Views | Created by TechVsLife2 - Friday, August 5, 2011 11:39 PM | Last reply by - Thursday, February 4, 2016 1:33 AM -
0 Votes
Error message when trying to apply Referential Integrity
When I try to apply referential integrity in linking two tables in Access 2007, I get an error message telling me I cant because ...Answered | 2 Replies | 800 Views | Created by tompas41 - Tuesday, March 25, 2014 1:42 PM | Last reply by Henry Habermacher - Thursday, March 27, 2014 5:01 AM -
0 Votes
Does export/import wizard guarentees and referential integrity???
Hi All, Just wanted to check if sQL server export/import wizard takes care of referential integrity while loading data which has parent child ...Answered | 3 Replies | 3612 Views | Created by Manu_vmr - Wednesday, September 21, 2011 3:48 AM | Last reply by Manu_vmr - Wednesday, September 21, 2011 6:40 AM -
0 Votes
ChangeTracker.DetectChanges() : a referential integrity constraint violation occurred
> My question is about, how with Entity Framework can I easily debug this kind of message?Answered | 4 Replies | 4611 Views | Created by Patrick Desjardins - Saturday, November 15, 2014 5:33 AM | Last reply by Fred Bao - Tuesday, November 25, 2014 8:38 AM -
1 Votes
Referential interity
Please check the following URL http://ibmmainframes.com/about16033.html Please kindly post c# related queries/Question in this forums.Answered | 4 Replies | 1500 Views | Created by Pink_1530 - Friday, August 17, 2012 11:38 AM | Last reply by Stefan Hoffmann - Friday, August 17, 2012 12:23 PM -
0 Votes
How can we create referential integrity between tables in different databases in same instance
But the elegant way to achieve the same is with the use of a CHECK constraint.Answered | 8 Replies | 10329 Views | Created by AjayChigurupati - Wednesday, February 10, 2010 7:24 AM | Last reply by RamyaN - Tuesday, March 30, 2010 11:32 AM -
1 Votes
Referential integrity cannot be enforced on circular relationships
It's working just fine, but I'm receiving this exception when calling: context.Resource.ApplyChanges(entityResource): (no other call to the context is made, after ...Answered | 3 Replies | 8054 Views | Created by juanfbp - Tuesday, February 22, 2011 11:35 PM | Last reply by Rune Gulbrandsen - Wednesday, February 23, 2011 5:32 PM -
0 Votes
Having trouble fixing database before migrating from ms access to sql, cant enforce referential integrity!
What referential integrity are you trying to enforce?Answered | 2 Replies | 3914 Views | Created by ShadowWorld - Wednesday, August 1, 2012 3:49 AM | Last reply by ShadowWorld - Friday, August 3, 2012 11:52 PM -
0 Votes
integrity check
As Ola'f said it performs the health check of the database in-terms of consistency .it is always good practice & Mandatory to schedule an checkdb.Answered | 2 Replies | 996 Views | Created by Surya.chamala - Tuesday, November 5, 2013 5:51 PM | Last reply by Rama Udaya - Wednesday, November 6, 2013 11:41 AM -
0 Votes
Referential Integrity fails for Access 2003 ADp against SQL Server 2010 R2
It is as if Access ADPs do their own referential integrity operations.Answered | 4 Replies | 4960 Views | Created by Synesis - Sunday, September 19, 2010 12:50 AM | Last reply by Synesis - Tuesday, September 21, 2010 3:10 PM -
0 Votes
Database Integrity check failed
How long does the integrity check take?Answered | 2 Replies | 16741 Views | Created by Melanie LeRoy - Monday, November 8, 2010 1:51 PM | Last reply by Kalman Toth - Tuesday, November 9, 2010 2:46 PM -
2 Votes
Check DB Integrity Task
The linke provided here http://www.sqlskills.com/blogs/glenn/how-to-create-sql-server-agent-alerts-for-critical-errors/.Answered | 3 Replies | 2052 Views | Created by Kalyan Chakravarthi (MCP) - Sunday, March 31, 2013 3:33 PM | Last reply by Ed Price - MSFT - Tuesday, April 2, 2013 9:18 PM -
0 Votes
Referential Constrains Across Files
So I don't think you can check referentianl constraints across several documents, unless you first programmatically merge them and then validate the merged document.Answered | 2 Replies | 3756 Views | Created by Ning - Tuesday, September 14, 2010 8:58 PM | Last reply by Allen Zhang - Sunday, September 19, 2010 12:56 AM - Items 1 to 20 of 2716830 Next ›
No announcements
