Trusted or disabled foreign keys

[gmmastros]

I'm working on a blog article, and I am curious to know how prevalent a particular "problem" is. Can you kind folks run the following query and tell me how many rows are returned?

SELECT name
FROM   sys.foreign_keys
Where  is_disabled = 1
       or is_not_trusted = 1

I don't need to see the results, but I am curious to know if anyone has disabled or untrusted indexes.

If anyone wants me to explain why disabled or untrusted foreign keys are a problem, let me know.

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[bborissov]

Zero records here

Borislav Borissov
VFP9 SP2, SQL Server 2000,2005 & 2008.

 

[gmmastros]

Thanks Boris.

Anyone else?

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[drlex]

Nada for me.
(SS2K5)

soi là, soi carré

 

[markros]

177 rows on our database.

PluralSight Learning Library

 

[Olaf Doschke]

0 here at home, I can tell you more about several real world servers tomorrow.

Bye, Olaf.