store procedure in SQL 2000 question

• Supernova Hakeem

  SSC Veteran

  Points: 254

  More actions

  February 18, 2011 at 4:20 am

  #234792

  How can I find out which content of a sp in a database in SQL 2000 quickly? I don't want to manually go to right-click properties and look at it. I want a better efficient way. Is it stored in a system table? Please let me know. Thanks.

• Ian Scarlett

  SSC-Insane

  Points: 23197

  More actions

  February 18, 2011 at 4:32 am

  #1288735

  You can use sp_helptext xxx (where xxx is the name of your stored procedure.

  You can also query the syscomments table directly.