storing data from SP

• Noman Tariq

  SSCommitted

  Points: 1750

  More actions

  November 24, 2005 at 11:55 am

  #66844

  Hi Sir,

  Im a new DBA and have a problem please guide me and give me the solution.

  my question is the ..

  " How can i store data from SP_HELP 'TABLE_NAME' into another Table?

  Thanks,

  Nomi

   

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  November 24, 2005 at 1:38 pm

  #605760

  create the table first then :

  insert into TableName (Columns) exec SP_HELP 'TABLE_NAME'