Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2005
    Posts
    22

    Question Unanswered: Listing procdure/trigger SQL code

    I would like to create a script that lists out all of the SQL code for the procedures and triggers I have created in a database.

    What I want to do is save the code for each procedure/trigger as a *.SQL file without having to open up each one in Enterprise Manager and save them individually.

    Listing the names is easy by looking in sysobjects, but is the SQL code stored in a system table anywhere?

    Does anybody have any alternative approach to this problem?

    Thanks in advance,

    Mark

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    I don't understand you problem. EM allows you to script out all the objects of any particular type(s) to separate files. There is nothing that limits you to one object at a time.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •