Thank you, this is what I was trying to don on my own but couldn't.

GF

So it looks like the consensus is:

select customer.name, company.name

from company

inner join customer on company.custid = customer.custid

where company.name like 'special company'

The reason for the question is, we too are going...

rhunt, the contact_id is not a foregin key in any table. The company_id is a foregin key to another table.

I was thinking along the same line as you but I...

the primary database is set to full recovery mode

Yes, SQl Agent is running on both the primary and the secondary servers.

It looks like I spoke too soon. I am not sure what is happening. When I look at the properties for the log shipping monitor the last backup file is...

Okay, here is an update. Log shipping from my primary server to my secondary server is now working and apperars to be working correctly.

what I did to get it to...

More information. SQL is Enterprise Edition on both the primary and secondary server.

I have though about this all weekend and perhaps this is the problem.

The folder I ship the logs...

Primary Server is Windows 2000 Latest Service pak running on a cluster.

Secondary server is Windows 2003 latest service pack on a quad processor.

Both SQL's are SQL 2000 sp3

igig of ram...

Thanks for all the replies. Here is what I have done to this point.

I would have bet money that the secondary server sql agent service was using the same domain...

Hi all, I found out what the prob is. It is a bug in SQL 2000 sp3. There is a hot fix for it at http://support.microsoft.com/default.aspx?kbid=826161

Gary

Chris, yes, that clears up my question. Thanks for your time and informaiton.

Gary

Chris, you are correct, I was mistaken. There is no "exec" after the "--".

Here is a classic example of what I am getting in my trace:

-- sp_sqlagent_get_perf_counters

SET NOCOUNT ON

-- sp_sqlagent_get_perf_counters

CREATE...

Thanks to all for the recomendations.

Gary

Thanks for your reply. what 3rd party tools would people recomend. I need to have alternatives to present.

Thanks again

GF