I try killing the exe for DB Mail.

I Did stop & start DB Mail.

I guess that I could probably stop & restart the service via Services.

Thanks for the feedback.

Goggle? What's that.:-)

Try Goggle Ignite.

David, I think your right about Ignite.

It makes it a lot easier to get the information and get it fast as well as examine what has been going on from...

ah. I will have to try that.

I ran sp's, search the DB Mails Tables in MSDB and basically went through the entire troubleshooting process so I would not double that...

I had suggested SSIS and to stay away from Linked Server a week ago yesterday.

On Thursday, I temporary cut his permissions and created an SSIS Package.

The Linked Server Load did...

I made sure that the Server was not restricted by the SMTP Server Relay.

I checked and the AV on that Server is the same as what is running on the...

Test did not work, checking into SMTP?

No suggestions?:crying:

Another consideration is that the AS400 is remote.

It would probably be faster to export the data from the AS400 to text and Load the text files into the AS400.

I noticed that the the Primary Keys are created on the Tables before the load.

I noticed that there are 10 columns for the primary key on the Accounts payable Table.

Most...

Indexes but no Primary Keys.

Thanks for the information.

I did not mention that this data is from a legacy DB2 Database that is hosted outside of the company and soon to go away.

None of the...

Thanks!

Rather than perform several SELECT DISTINCT to identify what combination of columns it takes to define the natural candidate composite primary key on over a hunded tables I would like...

Sean,

Each table is duplicated in a different schema.

Unfortunately I do not see a way to include the schema as a column and include that in the sort.