read commited and it's a simple view joining 2 tables, but the tables are big like 30k records each

Yeah I ran the sp_repldone and it works, I was able to shrink the log file

thanks for your help

I did that and I'm getting this error:

The log was not truncated because records at the beginning of the log are pending replication. Ensure the Log Reader Agent is running...

It's windows 2003, what is the way to map the drive then??

I did couple times try to map to another drive and nothing, it just do a backup to local drive...

Yes you can...

I found the problem.

the problema was on 2 table on MSDB database

1- select

* from dbo.sysjobs

2-...

there is NO Maintenance Plan, only a JOB, and I want to delete that job

Well, this one works.

SELECT * FROM LPUSA01...BZRCRP     WORKS !!!!

thanks

yes I do have all the patches up to date and client access also

select * from openquery(LPUSA01,'select * from bzrcrp')   this work, same connection and work

select * from LPUSA01.LPUSA01.EBSTSTNEW.BZRCRP   ...DO...

Yes ... the linked server is LPUSA01 and the server name is LPUSA01

That's my problem

I'm doing  linkedserver.datasourcename.library.table

             LPUSA01.LPUSA01.EBSTSTNEW.BZRCRP

work fine in anohter SQL server but does not work on the development...

I tried that and nothing same error, maybe Ineed to update the MDAC ??

select * from LPUSA01.LPUSA01.EBSTSTNEW.BZRCRP

this is a linked servr with AS400

first LPUSA01 is the linked server.

second LPUSA01 is the AS400 server name

third EBSTSTNEW is the catalog or Database

fourth BZRCRP is the...

But 2 tables where??  on As400 ?    I have no idea about 2 tables, How do I check for that??

thanks

That way doesn't work either because almost all the fields are not null, I cannot insert a row and then insert the values it won't work.

any other sugestions???

thanks