» » » SQL: Populate a table from stored procedure execution

SQL: Populate a table from stored procedure execution

,
Recently, in one of our projects we needed to create a SQL table based on the the result returned by executing the stored procedure. 
Following sql queries helped me achieve this;

EXEC sp_serveroption "MYMACHINENAME",'DATA ACCESS', TRUE


Select * into TempTable 
from OPENQUERY("MYMACHINENAME", 'MYDATABASE.MYSTOREDPROCEDURE')