Many times I need to write something like the following when dealing with SQL Server.
create table #table_name ( column1 int, column2 varchar(200) ... ) insert into #table_name execute some_stored_procedure;
But create a table which has the exact syntax as the result of a stored procedure is a tedious task. For example, the result of sp_helppublication has 48 columns! I want to know whether there is any easy way to do this.