Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2009
    Location
    India
    Posts
    50

    Unanswered: defncopy of all SPs in a database

    Dear Team,

    Could you please tell me, if there is any way to get defination copy of all stored procedures from a database to OS file?

    I believe defncopy utility can be used, but we need to explictly mention each stored procedure name.

    Instead, I want all the stored procedures. Is there any way to get my problem resolved?

    Thanks,
    Neevarp

  2. #2
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    Code:
    ddlgen -Uid -Ppw -ShostName:port -FP

Posting Permissions

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