unable to create view using linked server
Using Sql server as our database server - Tools 8.55.21
trying to create view using linked server ;
SELECT EMPLID
,HIRE_DT
,EFFSEQ
,NAME
,EMPLID
,LOCATION
, EMPL_STATUS
,BUSINESS_TITLE
, WORK_PHONE
FROM PSHRTST.dbo.PS_EMPLOYEES
error msg
SQL Build process began on 4/26/2018 at 11:19:54 AM for database PSFINTST.
Error: NJ_MIN_EMPL_VW - SQL Error. Error Position: 0 Return: 601 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'PSHRTST.DBO.PS_EMPLOYEES'.
CREATE VIEW PS_NJ_MIN_EMPL_VW (EMPLID, HIRE_DT, EFFSEQ, NAME, BADGE_ID, LOCATION, EMPL_STATUS, BUSINESS_TITLE, PHONE) AS SELECT EMPLID ,HIRE_DT ,EFFSEQ ,NAME ,EMPLID ,LOCATION , EMPL_STATUS ,BUSINESS_TITLE , WORK_PHONE FROM PSHRTST.dbo.PS_EMPLOYEES