By linked server I'm on about a linked server object set up on SQL Server with:
Exec sp_addlinkedserver N'<server name>', N'SQL Server';
EXEC sp_addlinkedsrvlogin '<server name>'
The view is set up on sql server with:
SELECT EmployeeCode, LastName, FirstNames, WorkAreaCode, LocationCode, DepartmentCode
FROM <server name>.<dbname>.<schema>.<table> AS EMPLOYEE_1
I've given select permissions on the view to a bespoke database role.
I've set up one user with login permissions on the remote server (as a test).
within the adp the view is visible similar to a linked table but it just wont open up.
I hope that clarify's things a little - my goal in all of this is to have the employees table from one system visible on the other so we only need to maintain the records in one place.
As for the adp's being deprecated; yep it's been on the cards for a while. It's days are numbered. There's a big job ahead changing formats.
Thanks for your help,