Questions tagged [database-link]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
2
votes
3answers
3k views

Determine last usage date of a linked server

We have a tonne of linked servers on our database server that we would like to clean up. Is it possible to determine the last date a linked server was used? e.g. the last time a query was performed ...
6
votes
3answers
11k views

Error Querying MySQL server linked to SQL Server 2008

I've created a linked server in MS SQL Server 2008 to a remote MySQL server. When I try to query any tables, I get an error: .tablename. contains no columns that can be selected or the current user ...
0
votes
1answer
38 views

How to select from pdbs with a cdb user?

I have several store procedures, which analyze oracle logs using log miner. These procedures run on CDB user C##ADMIN which created for this manner. Now I want to compare the logged values to the live ...