Post reply

Store procedures

  • July 27, 2009 at 10:01 am

    #133223

    Which table contains all store procedures that was created?Thank you

  • July 27, 2009 at 10:10 am

    #1030636

    I'm assuming you want to see the text of your procs....

    any of of these will get you started:

    select * from INFORMATION_SCHEMA.ROUTINES

    select * from sys.all_sql_modules

    select * from sys.procedures --just procs

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • July 27, 2009 at 10:10 am

    #1030637

    No idea offhand what the base table is, but the system view is sys.sql_modules

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • July 27, 2009 at 1:55 pm

    #1030728

    I've always found the text in syscomments.

    The probability of survival is inversely proportional to the angle of arrival.

  • July 27, 2009 at 2:19 pm

    #1030740

    sturner (7/27/2009)

    I've always found the text in syscomments.

    Which is included in SQL 2005 solely for backward compatibility, is deprecated and will be removed in a future version of the product.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply