Home Forums SQL Server 7,2000 T-SQL create a table on a 2nd SQL server via linked server RE: create a table on a 2nd SQL server via linked server

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