sp_sproc_columns

• dr43058

  SSC Journeyman

  Points: 86

  More actions

  April 4, 2012 at 3:59 am

  #254266

  Trying to return sproc metadata (only input paramaters) by using sp_sproc_columns. So I tried modifying it by adding WHERE COLUMN_TYPE = 1, but when I tried running the query, I got the following error message;

  Msg 208, Level 16, State 1, Line 205

  Invalid object name 'sys.spt_sproc_columns_odbc_view'.

  Also, I am logging into SSMS 05 with Windows account. I have tried miserably to configure my SA account but nothing seems to work. Please help!

• Eddie Wuerch

  SSChampion

  Points: 12535

  More actions

  April 4, 2012 at 4:23 pm

  #1469214

  If you're making your own version of the proc with custom mods, try marking it as a system procedure:

  EXEC sp_ms_marksystemobject 'your proc name'

  -Eddie

  Eddie Wuerch
  MCM: SQL