hello, i am running into the same issue...how can i execute the output of SP on a remote server linked server..
Exec ('use Test_Script exec dbo.Test_CreateTable') at [ABC-DEV]
Msg 2812, Level 16, State 62, Line 1
Could not find stored procedure 'dbo.Test_CreateTable'.