Could it all be permissions related?
BOL (http://technet.microsoft.com/en-us/library/ms186301.aspx)...
"built-in functions such as OBJECT_NAME may return NULL if the user does not have any permission on the object"
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.