ColinGregory
Technical User
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.
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.