I am looking at using cfdbinfo tag that can introspect a Linked SQL Server Setup.
The server setup is as follows:
Coldfusion as a datasource cftest that points to SQL Server A
SQL Server A has an established link to SQL Server B
I can query using cfquery information from server B by going
Select * from SERVERB.Database.dbo.table
However, this tag setup does not return the name of the table
<cfdbinfo type="columns" name="test" table="table" />
This errors out as the table does not exists.
Also experiencing this issue, any help would be greatly appreciated!