Scripting Options

Question

Scripting Options

Jeff Moden

SSC Guru

Points: 1004356
More actions
January 15, 2010 at 9:13 am

#138269

I'm working on an instance of SQL Server 2005 (Standard Edition) for a new company. I want to set the scripting options so that when I right click on a table and gen a script as "Create to"", I can tell it things like to not script collations, etc.
I thought those options were under [Tools][Options][Scripting Options] and Books Online says that's where they're supposed to be, but that option does not appear under [Tools][Options] for me.
Or, I may have finally lost my mind. 😛 Where does one set these scripting options for the Object Explorer?
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 8 posts - 1 through 7 (of 7 total)

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

J-F Bergeron SSCrazy Eights Points: 8593 More actions · Answer 1

Jeff Moden (1/15/2010)
I'm working on an instance of SQL Server 2005 (Standard Edition) for a new company. I want to set the scripting options so that when I right click on a table and gen a script as "Create to"", I can tell it things like to not script collations, etc.
I thought those options were under [Tools][Options][Scripting Options] and Books Online says that's where they're supposed to be, but that option does not appear under [Tools][Options] for me.
Or, I may have finally lost my mind. 😛 Where does one set these scripting options for the Object Explorer?
Thanks folks.

In [Tools][Options], I can see a node called [Scripting], when you open the Options Menu. I can specify if I want to include collation, or any kind of settings for scripting there. I'm on SQL server 2005 Developper SP2. Does that help?

Cheers,

J-F

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

Heh... thanks for confirming that I haven't lost my mind (at least not all of it). That [Scripting] node doesn't exist in the [Tools][Options] dropdown for me. I wonder what they've done to this system to make it disappear? Guess I have a little investigative work to do.

Hmmm... do you know if SQL Server Express might have such a limitation?

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

J-F Bergeron SSCrazy Eights Points: 8593 More actions · Answer 3

I just tried using SQL server 2005 Express SP2, (With the Express studio) and the option is there too. I find it pretty odd that you can't see this option, might this be a server setting?

Cheers,

J-F

Jeff Moden SSC Guru Points: 1004356 More actions · Answer 4

Dunno... I've never seen this particular problem before. Doesn't seem to be an "instance" setting, either.

Thanks for the help... guess I'll have to throw a rock at the boys in NY.

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

J-F Bergeron SSCrazy Eights Points: 8593 More actions · Answer 5

Heh, my pleasure, it's not everyday you get to assist the Great Moden himself,

Have a nice one,

Cheers,

J-F

Jeff Moden SSC Guru Points: 1004356 More actions · Answer 6

:blush: Thanks, J-F. Both for the help and the nice compliment.

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

Jeff Moden SSC Guru Points: 1004356 More actions · Answer 7

I got ahold of the System's DBA on this problem. Appears there was an aborted attempt at installing SP3 because the instance properties said it was at SP3 but Reinstalling SP3 fixed the problem.

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