Hi,
i've a similar proble. I've some procedures that uses a oracle linked server, but:
- if i run manually procedures no errors occur
- if i run them in a scheduled process it breaks for inconsistent metadata
- i've no idea which tables/views are the problem source, how can i investigate on it?
- i've tried to use Profiler without success
thanks