How do I configure SQL Profiler to show me queries to the views sys.databases and sys.tables?
There's nothing inherent in Profiler that would prevent those queries from being displayed. I think you're just not catching the right events. It sounds like you're filtering for Stored Procedure events. Try also filtering for TSQL events.