Hi Again,

I've just added another server named "BP-SQL\BPSQLSERVER" and I'm having issues executng a query from the main server. Here is an example

SELECT p.PatientID, p.LastName, p.FirstName, '1' as ProgramId

FROM [BP-SQL\BPSQLSERVER].dbo.PATIENTS p

I've also tried although I had a feeling these would not work

[BP-SQL.BPSQLSERVER]

[BPSQLSERVER]

[BP-SQL]

Please help.