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')



profile for Nadeem Yousuf at SharePoint Stack Exchange, Q&A for SharePoint enthusiasts

+