locked
can i get the output of 'sp_columns' system SP into a table through T-SQL RRS feed

  • Question

  • Hi,
    I want to collect the output of system stored procedure 'sp_columns' into a temporary table. Please suggest how can i achieve this.

     

    Ashu Sharma

    Tuesday, January 31, 2006 9:18 AM

Answers

  • Create a temp table with columns as described at sp_columns in BOL and then do
    INSERT INTO your_temp_table EXEC sp_columns
    --
    Frank Kalis
    Microsoft SQL Server MVP
    http://www.insidesql.de
    Tuesday, January 31, 2006 9:56 AM

All replies

  • Create a temp table with columns as described at sp_columns in BOL and then do
    INSERT INTO your_temp_table EXEC sp_columns
    --
    Frank Kalis
    Microsoft SQL Server MVP
    http://www.insidesql.de
    Tuesday, January 31, 2006 9:56 AM
  • Thanks Frank
    Tuesday, January 31, 2006 10:18 AM