Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2005
    Posts
    3

    Unanswered: how to export only the stored procedures to a file ?

    hi,
    I am new to Sql Server and I want export the stored procedures of my SQL Server 2000 database
    to a flat file, so I can import it later to another SQL Server 2000 database (it is not anywhere in the network).

    Can anyone explain me the easiest way to do that ?

    Thanks !

  2. #2
    Join Date
    Feb 2004
    Posts
    88
    go into enterprise manager and highlight the server/database you wish to export from in the left hand pane. Then go to tools/generate sql script.

    click the "show all" button, and then check the "all stored procedures" box.

    on the "options" tab you can choose to create one file (for all the sp's) or one file per object.

    HTH,

    Bill

  3. #3
    Join Date
    Mar 2005
    Posts
    3
    thanks for your help, it works fine !

Posting Permissions

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