February 4, 2011 at 11:42 am
I have two FK that are in a not trusted state and i can't get them to be trusted. DBCC CheckConstraint completes with no errors, the alter table with check check constraint also completes with no error, but still has is_not_trusted set to true.
any suggestions?
Thanks
February 4, 2011 at 11:47 am
Is it possible that they are disabled?
Usually, dropping and re-creating (with check) is the best way to get them trusted.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
February 4, 2011 at 11:51 am
dropped and added both of them, both are still not trusted, I even queried to check for violations and didn't find any, but they still show as not trusted. I don't get it.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply