You can replicate to Oracle 8i so I presume you can replicate to 9i.

As for the reverse, I seem to remember reading that you would need to code the reverse...

Hope the info helps.

Had the same problem a couple of weeks ago.

There is a xp_sendmail bug in Sql Server SP2. See Q320407 for more details.

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q320407

There is a little more info on...

There is a registry key fix you will need to do. See books online for details (search for

'ole db provider for oracle') for details.

Also make sure the tns files...

As it is a production server and my workaround is fine (for the time being).

I'll wait for the SP3 fix rather than replacing the dll

thanks

I've done it with sql 2000/exchange 5.5 by using a linked server. Exchange 5.5 is a ldap datastore.

For example

EXEC sp_addlinkedserver

You can add the net library to the connection string

Add NetworkLibrary=<library>; to the library

where <library> is one of the following

dbnmpntw - Win32 Named Pipes

dbmssocn - Win32 Winsock TCP/IP

dbmsspxn...

When the database is in simple mode, it still uses the transaction log to ensure integrity. It just deletes the transaction after everything is safely written to the data portion...

I played with it once.

You need office xp on your pc + either the enterprise or developer version of SQL2000.

Once you have those on a pc, you load either of...

Sorted it for the time being by moving the xp_sendmail process onto a sp1 box.

Update.

Worked round it by setting up the subscriber to read a local snapshot folder, and copied it in from the remote server.

Not ideal as anytime in need to reinitialise it...

Fixed that part, now onto the next.

I run a profile trace and found that because I had connected to the remote server with its domain suffix the 'exec sp_helpdistpublisher' used...

With standard roles, you assign user account to the role. ie they need a account to gain access to the sql server and database.

With Application roles the application logs onto...

If you are worried about performance, see if you can rewrite the sp so you don't use a cursor.

eg. Derived tables, table variables etc

Have you taken a look at the install logs, so see why it wasn't installed?