Unfortunately, this is not a...

I have tried Jeff's method of using sp_ReadErrorLog on our SQL2000 and ran into the following:

When the records shorter than the Content field it works no problem.

When the records were longer...

Could also do the following:

select * from Tbla

join tblb

on tbla.id = 'Link_' + tblb.id

Thanks Daniel,

That worked just fine. Too obvious a solution for me to have thought of. Guess it's just a flaw with Ent.Mgr.

Don

PS - "Microsoft Mystery"? Isn't that a redundant phrase??...

The AS400 has a primary, the SQL doesn't, but this doesn't seem to bother the query is run in the View design screen (or Query Analyzer). Only when I try...

Maybe. Can the selection criteria be passed from report to report when you do that?

Thanks Wendy

As I understand it that would run the proc. from the report which would work for the first report. I was trying to prevent the user from having to...

It would seem that the journalling was the issue.  Once I journalled the file I was able to update it using either the whether I used the IBM DB2 UDB...

What should the 2nd param. be. In SQL it is the owner, but for a 400 query???

My current syntax has the LinkedServer as #1, Library as #3, and File as...

Hi Jeff,

I was using the IBM ODBC with the IBM DB2 UDB OLE DB  in th linked server.

I have created a new ODBC and an new linked server using the...