December 20, 2002 at 6:16 am
Hi! Question: I have an SQL Server 7.0 running jobs (as SA), which makes queries against a linked server. This linked is an Oracle 8.1 running at his full capability, sometimes the connections (on the Oracle side) hangs up and i see the sql processes as actives, even they are doing nothing. If i try to kill them, i have no response, until the procceses are killed from the linked side. How can i handle this? I can't kill this procceses because they are logged as SA?
TIA, and sorry by my raw english 🙂
December 20, 2002 at 10:04 pm
It is a problem with any linked server connection, even when both sides are on SQL Server. Basically, you cannot send the kill command to a linked server. Well, imagine security implications if you could.
However, if there is a better answer, it would be great.
December 21, 2002 at 7:47 am
Unfortunately mromm is right. I went thru this for quite a while with our Oracle servers. Better indexing on there side and writting cleaner code on our side solved this some. We ultimately do a lot of work to get the need to talk to Oracle out. Some by transferring the data inoto SQL and some by letting the reports on the Web hit the Oracle box.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply