Help configuring Object Browser Scripting Options

  • Heh... good ol' Microsoft... I just completed installing 2k5 Dev and I'd first like to say something about the interface... WHAT A PIECE OF CRAP!!!!

    Ok, I've got that out of my system. 😉

    In SQL Server 2k, in Query Analyzer, you used to be able to right click on a table and tell it to gen the script for the table. Yes, I know you can still do that in 2k5... but how do you set the scripting options? That doesn't appear when you right click anymore. I'd like to suppress things like the object header and collation, etc, etc.

    Thanks, folks...

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

  • Unfortunately, there isn't any option to set scripting options for the selected object. You'd only have to take what the SSMS gives you by default. However, you can change these default scripting options through Tools > Options > Scripting.

    Scripting options can also be set when generating scripts by right clicking on database > All Tasks > Generate Scripts.

    Apparently, you would be surprising to see some useful features disappeared!!!:D

    --Ramesh


  • Ramesh (12/10/2007)


    Apparently, you would be surprising to see some useful features disappeared!!!:D

    Heh...you've got that right...

    Thanks for the info, Ramesh... add one more chunk... the scripting options you told me about are not available on the raw install... you have to install the latest service pack for them to appear on the menu. I'm happy to see that there are actually more scripting options... 🙂 First thing I've seen them do right on 2k5 yet.

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

  • :hehe: Glad to see I was not the only one to discover this feature or is it lack of Feature.. and you will also find that if you don't install at least sp2 you will not be able to use custom reports which is a great feature

    CodeMinkey

Viewing 4 posts - 1 through 3 (of 3 total)

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