Hello,

I had the same problems with SQL Server 2008 R2 with ODBC. When connecting to any database all systemviews from db master were shown in addition.

I have done following in the management studio: After selecting db master, properties, I added the role public in rights and revoked "select". That was all!

Did you try this already?

In ODBC-Management "Sql Server native client 10"-driver is a must! With older versions it does not work.

New ODBC-connections can only be created with accounts without "public"-membership!

best regards

Martin