Information_Schema on linked server

[NathanGriffiths]

How do I reference Information_Schema in a database on a linked server?

If I use

SELECT * FROM Server.Database.Information_Schema.Tables

for example I get the error:

Server: Msg 7314, Level 16, State 1, Line 1
OLE DB provider 'Server' does not contain table '"Database"."information_Schema"."Tables"'. The table either does not exist or the current user does not have permissions on that table.

I can query the sysobjects table but I would rather use the the information_schema instead if possible.

thanks,

Nathan


Want to get a good response to your question? Read this FAQ! -> faq183-874

 

[vadimg]

If your account can read from sysobjects, you shouldn't have a problem selecting from information_schema.

this error looks like a syntax error. check if your linked server is case sensitive. if so, try this:

SELECT * FROM SERVER.master.INFORMATION_SCHEMA.TABLES