Lowell - Monday, January 23, 2017 8:21 AM

duplicate post.
no need to cross post to multiple forums it fractures the answers you get and makes posters duplicate others work.
the "Latest Posts" link shows us everything.
continue the thread here:
https://www.sqlservercentral.com/Forums/1852098/Identify-objects-that-do-not-use-an-Identity-Column-but-a-Lookup-Table-to-generate-an-Unique-Identif

specifically you've ignored all the previosu advice to use sys references data. go back to the original thread, and show what you've tried so far