Maybe you have an application which uses the sa password. Create a trace with profiler to trap this kind of events (Security Audit - Audit Login Failed)

Hope this helps.

Have you checked all the available processors in the processors configuration item?

My machine is the only one running AS Manager on the network

I´m using the same 'elegant' method, but i think that our friends from Microsoft should be developed some utility, exe, command or whatever that let us do that in a...

You could try to find which is the sp that stores the instruction, and then take a look to the permissions. Script all the sps through EM, and find the...

I can do it running a batch with this string:

isql -S server -U sa -P password -d userdatabase -Q "exec SP" -o salida.txt

Late answer, but who knows...maybe still could help...

thanks a lot, Steve. I will try it

nobody?

upa!

i can´t imagine how can i do that on 6.5 version...  

-See if from the sql server box you can tnsping the box.

Works Ok

-then see if you can connect native via sqlplus. 

Works Ok

-Then validate a simple connection via the msdaora...

MSDAORA. Also using Oracle provider for OLEDB.

Runnig the commands, the information is the same:

Server: Msg 7399, Level 16, State 1, Line 1

OLE DB provider 'MSDAORA' reported an error. The provider...

I get this error when i try to see the Oracle tables shareds (through EM, for example). Of course, if i run a distributed query i get the same error...

Up!

Frank, thanks for your help. I take a look on the link (you was dealing with the same issue, right?), and realize that the most simple solution, i mean check...