Well it is 2012 March and I am using SQL Server 2008 R2 and having the same problems SQL S 2005 folks 3 yrs ago had. Anyone come across a solution or work around for the part when making a ODBC connection to sql server 2008 r2 dbase that the connection does not show information_schema and sys objects? I see this is still a problem but outside of scripting every object in database 'mssqlsystemresource' as deny(not really what I was looking for). Anyone have anything on this?