none
Strange link in a linked serve query statement

    Question

  • Hi guys, I got a data warehouse with a lot of Oracle linked server. In one of this Oracle db I got a table with several query description and sql statement. Pretty useful if you want check the table. Now sometime as query statement I got like something

    class:usa.lt.wat.rep.server.MIReportSalesManagement (usually I got the query, even if is an Oracle query)

    and I'm wondering what is. I guess is a link to a report but I can figure out what is really...

    Any idea?

    Wednesday, August 20, 2014 10:13 AM

Answers

  • Let's see, you see something that comes from an Oracle database, and you ask in a Transact-SQL forum what it might be?

    You will need to talk with someone that knows about the data in this table in this database on this server.


    Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
    • Proposed as answer by Olaf HelperMVP Wednesday, August 20, 2014 10:54 AM
    • Marked as answer by DIEGOCTN Wednesday, August 20, 2014 12:48 PM
    Wednesday, August 20, 2014 10:39 AM

All replies

  • Let's see, you see something that comes from an Oracle database, and you ask in a Transact-SQL forum what it might be?

    You will need to talk with someone that knows about the data in this table in this database on this server.


    Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
    • Proposed as answer by Olaf HelperMVP Wednesday, August 20, 2014 10:54 AM
    • Marked as answer by DIEGOCTN Wednesday, August 20, 2014 12:48 PM
    Wednesday, August 20, 2014 10:39 AM
  • I see the point. Just asked for some eventual experience...

    Wednesday, August 20, 2014 12:48 PM