Help configuring Object Browser Scripting Options

Question

Help configuring Object Browser Scripting Options

Jeff Moden

SSC Guru

Points: 1004339
More actions
December 9, 2007 at 9:07 pm

#119353

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)

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

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

Ramesh Saive SSC-Insane Points: 24275 More actions · Answer 1

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

Jeff Moden SSC Guru Points: 1004339 More actions · Answer 2

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)

Kevin Brennan Right there with Babe Points: 738 More actions · Answer 3

: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