Information_schema views unavailable/hidden

[ColinGregory]

Easy question for somebody

I'm trying to access the INFORMATION_SCHEMA views to build a configuration report for the database. However, no information schema tables are showing up in the views list and if I try to grant permissions via T-SQL I get an object doesn't exist error. None of the INFORMATION_SCHEMA's are showing in any login properties boxes. I'm sure I've missed something simple like a tick box somewhere but I can't find anything in BOL or elswhere.

Can anybody point me in the right direction??
Thanks in advance.

 

[tlbroadbent]

The information_schema views are only found in the master database. They are system objects so they can be referenced from any other database and will show the schema of the current database. If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm