Can you check Microsoft Knowledge Base Article - 264012 :

PRB: Connectivity Issue with MDAC and Oracle8i

You might have to add some reg-keys, mentioned in the article.

Maybe defeat it with it's own weapons ?

use master

select object_id('sp_schedule_status_reset') as The_Nasty_One

just my 2ct.

- did you configure the mail-profile when logged in as sql-agent-service-account ?

- does your sql-agent-service-account has the needed authorities for that email-profile ?

- Is it working when you...

When I install new basic software (Oracle client in this case) I alway reboot.

Especialy when installing on a server. This way I can better relate a problem to a last...

Indeed

I suppose your sqlserver-agent-account is member of windows-server-administrators group ?

If not, you'll need to give it access to the Oracle-folders and reg-keys.

You might also want to login on the server...

Hi Andy,

1) When a forum-thread is started as a "comment-on-article", the article is mentioned as text-http-reference.

e.g.:

"Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/dpoole/sqlserverstatisticalfunctions.asp

========================"

Can you...

did you define the ODBC as system-dsn ?

Maybe this litle article gets you back on track :

http://www.sqlservercentral.com/columnists/fkalis/coddsrules.asp

It's a nice refresh Frank -Sharky-  has written to the benifit of all...

What bike ? (changed the avatar for a couple of minutes to SushiNemo)

I hope the original poster...

identity is related to a numeric datatype so leading zeroes are meaningless.

You can present them anyway with things like this :

DECLARE @I INT

DECLARE @C CHAR(8)

SET @C = ''

SET @I =...

On the other hand, I cannot prevent it !

I can tell my windows-group-administrators, but that is as good as a flyer. You spread the...

you can also change de database-ower (exec sp_changedbowner @loginame = 'theOneAndOnly' ,@map = 'true' ) Then that user by default creates dbo-objects. If he/she wants older existant 'theOneAndOnly' -tables, he/she...

You should run OUI and perform a custom installation. There you can check Windows-components.

Arch ... also the married restrictions

Missing the adrenaline, but having your socks washed every week

Even the...