Accessing System Views via linked servers

Is there anyway to access system views on/from a linked server?
I have unsuccessfully tried various permutations of
select *
from [MDEDATAWTD\ss2005].master.[information_schema.colums]
ThanksYou are making the table and column name appear as one object. This works fine for me:


SELECT *
FROM [MyServer].master.information_schema.columns
2005 also. High priveledge linked account.

HTH|||You are making the table and column name appear as one object.Not very helpful huh?

I mean with this:

...[information_schema.colums]|||Thanks.

It is not working for me even though I can access the data bases directly. I am going to try a different tack. This approach is chewing too much time.|||Ok - but if you do decide to stick with it check that your linked server maps to an account with the correct privledges. Remember - your domain account could be locally mapped to a remote SQL account that has insufficient rights.

I suppose we'd need to know the error too.

Anyway - just a thought :)|||Thanks for the additional insight.

I also discovered that I really didn't want the system tables from a "linked server" but the system views from a database on the "linked server". Either way I could not get it to work. As I said the benefit gained by procedurally scripting the change looks to be longer than just manually doing the change.

FYI: The error was of the "object does not exist" variety.|||Awww, c'mon Bartron...don't give up now! :) You'll need the linked server experience somewhere down the line!

It's very common for the "object does not exist" error to be due to permissions issues as previously pointed out.