Question: DECLARE @RunStoredProcSQL VARCHAR ( 1 0 0 0 ) ; SET @RunStoredProcSQL = 'EXEC ctw . [ dbo ] . [ nca _ opentimeupdates ]
DECLARE @RunStoredProcSQL VARCHAR;
SET @RunStoredProcSQL 'EXEC ctwdboncaopentimeupdatesFCCAOTA;
EXEC @RunStoredProcSQL AT CTWPSQLQE;
Print 'Procedure Executed';
The above SQL Server Query I am using in SSMS
but the stored proc is created in PSQL
Below is attached SS for Stored proc.
So i want to run this PSQL stored proc from SQL server SSMS server
Linked server is created for CTWPSQLQE and working fine.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
