For anyone who's played with importing data from calldetail, you've probably noticed the table is not visible when trying to link to it from various sources. However, you can create direct queries that will run against it without issue.
Apparently SQL Server is not so tolerant. I have linked servers set up for each of my switches, and for any other table I've been able to schedule jobs to pull data on given intervals (usually from call_today).
However, I now have a need to pull data from call detail using a link server in SQL 2k. If I try to query it, SQL returns an error that the table does not exist. I know calldetail is a special public synonym in the Oracle side of things.
Has anyone tried accessing this table from SQL Server with any success? If so, what'd you do?
Apparently SQL Server is not so tolerant. I have linked servers set up for each of my switches, and for any other table I've been able to schedule jobs to pull data on given intervals (usually from call_today).
However, I now have a need to pull data from call detail using a link server in SQL 2k. If I try to query it, SQL returns an error that the table does not exist. I know calldetail is a special public synonym in the Oracle side of things.
Has anyone tried accessing this table from SQL Server with any success? If so, what'd you do?