It may not be the best way and you may be able to wrap an sp_msforeachtable with the sp_msforeachdb procedure but here is one way to iterate over each database...

I would have to agree, the use of NULL itself does not violate RFI.

Even a simple definition via Google clarifies what RFI really is. All RFI is really doing...

Coincidentally I started an internal article for my company, the same day this was posted, on Referential Integrity (RFI).

Some other considerations for a lack of RFI are poor database...

I have not read all of the responses so perhaps someone else has pointed this out already but the title references "with no Indexes". However you referenced an Indexed View...

Loner (1/2/2009)

---

DBA is different from SQL Developer and I think being a developer, industrial experience is very important. I used to work with people coming out of college without...

I can see an argument both ways. While it is true that

, not all DBA and or SQL positions are specifically geared towards trawling through stored procedures...