TSql Script

• burahdi

  Old Hand

  Points: 350

  More actions

  May 12, 2004 at 4:35 pm

  #152140

  Hi All

  Could you please help me with a script? I want to list all the stored procedure names, owner, type and create date in a database.

  I have written a script that list all the SP name's using the sysobjects table but cannot find the other information about them (owner, type and create date)

  Here is what I have done so far:

  select name, type

   from sysobjects

   where type = 'P'

  Thanks

  Dinesh

   

   

• Phil Parkin

  SSC Guru

  Points: 246964

  More actions

  May 12, 2004 at 5:38 pm

  #506222

  Try this:

  select top 10 * from information_schema.routines

  where routine_type = 'procedure'

  and then refine to get the fields/data you want.

  The absence of evidence is not evidence of absence
  - Martin Rees
  The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
  - Phil Parkin

• burahdi

  Old Hand

  Points: 350

  More actions

  May 12, 2004 at 6:19 pm

  #506223

  Phil

  Thanks very much, exactly what I was after.

  Dinesh