Hi Bob,

I think I'm getting somewhere.....

I tried both of what you suggested and both failed. Telnet said 'could not open connection to host' and the linked server using the port...

Hi,

Thanks for the info.

I'm a little bit unsure on some of these questions such as the ports and firewall. As far as I know there are no restrictions in the...

Hi,

Yes that works, I'm just at a loss to understand why it didn't work using my login baring in mind I have another server on the same domain connecting to...

Hi,

Thanks for the reply.

Would that though give anyone in the forest permission not just the local domain the SQL server sits on?

Andrew

Hi,

Thanks for that. I've managed to get it working in a very similar way to which you suggest.

I will make sure I produce sample code as you guys recommend...

sure.this is the query I've got that gets me to a certain point.

I've a feeling I'm going about it the wrong way though 🙂

select

tableB.tableid,

a.person ,

tableB.date,

case when tableB.ClosedReason...