Thanks for the replies folks.

I think the ports must be open because I can receive the test emails

I generate using "Database Mail | Send Test E-mail" in Management Studio.

I've got the same problem folks - any joy ?

Having this problem too - any updates ?

Thanks for the reply.

Ideally I'd like something that would be just write out the Rollbacks, as opposed to having to scan through big files.

In the meantime I'll set up a...

Thanks again for the reply Damien.

xanthos - you're a genius !! Thanks so much.

Fair play and thanks.

Thanks for the reply there.

The offending item is circled in red in the GIF attached.

Thanks for the suggestion Mobasha

I think I have a solution now.

I created a sproc on Server B to run the job using EXECUTE AS TheWindowsLogin

I then...

Thanks for that Mobasha.

That won't work for me though because I want to run a job on Server B that requires access to a network drive.

Omar, I had this problem too - it was fixed by installing SQL Server 2000 Service Pack 3.

Erik, you need to go to Control Panel | Services and double click...

No problem - glad I could help.

Make sure you have a login on the remote server (you'll have to get someone to check this for you).

When you linked the tables in Access, did you select the "Save password" option on the screen where you pick the objects to link ?

From Access Help

"Dim strGetSQL As String

strGetSQL = "SELECT TOP 10 Products.[ProductName] " _

& "AS TenMostExpensiveProducts, Products.UnitPrice FROM Products " _

& "ORDER BY...

You can connect to an Access database that is secured with a database level password if you set up an ODBC System DSN which specifies the DB password and then...