Runtime error data provider or other service provided an efail status

Anyone knows what would cause this?When Enterprise Manager is used to open a table
Runtime error data provider or other service provided an efail status"Vincento Harris" <wumutek@.yahoo.com> wrote in message
news:2fa13ee7.0409220419.1d9dc812@.posting.google.c om...
> Anyone knows what would cause this?When Enterprise Manager is used to open
> a table
> Runtime error data provider or other service provided an efail status

It would be useful to know the exact error, however Google suggests that a
corrupt DLL may be one cause:

http://groups.google.com/groups?q=s...f=1&sa=N&tab=wg

Probably the easiest thing to do is uninstall then reinstall the client
tools, then apply the latest servicepack.

Simon

running status for jobs

Hello all,

I would like to know how to how to know through sql queries if a job
that was processed is still running...

I tried to use msdb..systasks but it doesn't seem to help (status not
running and status running only).

Thanks in advance for your answer.

AndyHi

You could use "master.dbo.xp_sqlagent_enum_jobs"
--

Jack Vamvas
___________________________________
Need an IT job? http://www.ITjobfeed.com/SQL
<Andy.H.Kwok@.gmail.comwrote in message
news:1190367292.261350.224760@.r29g2000hsg.googlegr oups.com...

Quote:

Originally Posted by

Hello all,
>
I would like to know how to how to know through sql queries if a job
that was processed is still running...
>
I tried to use msdb..systasks but it doesn't seem to help (status not
running and status running only).
>
Thanks in advance for your answer.
>
Andy
>

sql