Active Directory, AS/400, Business Intelligence, CIO, Cisco, Database, DataCenter, Desktops, Development, DNS, Exchange, Exchange 2003, Exchange 2007, Hardware, iSeries, Linux, Lotus Domino, Lotus Notes, Management, Marketing Technology, Microsoft Access, Microsoft Excel, Microsoft Windows, Mobile, Networking, Oracle, OS, Outlook, Outlook 2003, Outlook 2007, Routers, RPG, RPGLE, SAP, Security, Servers, SQL, SQL Server, SQL Server 2005, Storage, Tech support, Virtualization, Visual Basic, VoIP, VPN, Windows 7, Windows Server, Windows Server 2003, Windows Server 2008, Windows XP VIEW ALL TAGS
In MS SQL 2005, when I select * from VIEW_TABLE_USAGE, I get incomplete results. At least one object that is used in at least one of the views is not listed. View "PTP__MARA_MARC" uses two tables and one view, but VIEW_TABLE_USAGE only lists one table and one view. Can you please help?