Unable to generate script

  • Hi ,

    Im tryinig to Generate Script for all tables, StoredProcedures ,Functions in a database using Tasks->Generate Scripts->Select Specific Objects->Advance->Drop And create.

    Unfortunatley few Functions and a SP is missing.

    Kindly let me know if any thing i need to turn on ..

  • Are you unable to select the functions and the SP or are they missing in the generated script?

  • Are they encrypted?

  • they are missing in the script..

  • greeshma.patla (8/17/2012)


    they are missing in the script..

    My point is, encrypted stored procedures (or other objects) will not be scripted.

  • Functions and SP's whihc are missing in the script are not encrypted one's

  • To my surprise ,when I select Functions alone all the functions scipt is generated,Sme is the case with SP's.

    But when I Generate Script for entire DB or Select both functions and SP's then few of them are missing..

    Please suggest me a solution

  • greeshma.patla (8/17/2012)


    To my surprise ,when I select Functions alone all the functions scipt is generated,Sme is the case with SP's.

    But when I Generate Script for entire DB or Select both functions and SP's then few of them are missing..

    Please suggest me a solution

    It sounds like you've correctly identified both the problem and a "solution". Why not just do it that way?

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 8 posts - 1 through 7 (of 7 total)

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