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...