1 Reply Latest reply on Oct 17, 2013 6:31 AM by acline3

    Can cfdbinfo retrieve tables for Linked SQL Servers?


      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.


      Any Advice?