Post reply

Unable to generate script

  • August 17, 2012 at 12:34 am

    #279846

    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 ..

  • August 17, 2012 at 3:14 am

    #1526967

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

  • August 17, 2012 at 3:48 am

    #1526986

    Are they encrypted?

  • August 17, 2012 at 4:20 am

    #1527007

    they are missing in the script..

  • August 17, 2012 at 4:27 am

    #1527010

    greeshma.patla (8/17/2012)

    they are missing in the script..

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

  • August 17, 2012 at 4:30 am

    #1527012

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

  • August 17, 2012 at 4:36 am

    #1527017

    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

  • August 17, 2012 at 10:11 pm

    #1527296

    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