SQL Server Performance Forum – Threads Archive

information schema

Hi all,
I cannot use the information schema across linked servers as written below. Should I be able to ? select * from <[linkedsrv]>.<db>.information_schema.tables A direct query like this works fine
select count(*) from <[linkedsrv]>.<db>.dbo.<table>

---

If all rigths are Ok, yes you can. Luis Martin …Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
Bertrand Russell

---

Using four part name is an alternative to accessing tables in a linked server and is a one-time,
adhoc method of connecting and accessing remote data using OLE DB. The OPENROWSET function can be referenced in the FROM clause of a query as though it is a table name. REfer to books online for OPENROWSET topic for more information. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com

---

]]>