Have a number of linked databases from other servers, cause that's just the way we roll around here

My problem, have found the database I want to extract code from, have displayed the tables, but it won't allow me to display either the column names or run an SQL statement across the database.

Anyway around this, don't have access to the source server without promising my first born or South Australia ....