I had the same issue on a server that was receiving a huge number of very fast queries. The issue is that there was 1 or 2 queries that did...

Actually my problem is only with schemas. I have a contact at MS researching the issue I will post here what he finds out. Here is what I found. ...

Found that SQL 2008 SSMS must have a bug of some sort. User has right to select from the schema. In SSMS 2005 user can see all tables owned by...

I am having the same problem described here. I am upgrading from SQL 2000 to SQL 2005. It is a 3rd party app that uses a sql login who owns...