how to set options ONCE?

[DLu]

Very often, when I generate SQL scripts for a table, I forget to go to Option tab to click the pk, default, index boxes. Is there a way to permernatly set the whole sql server generate sql scripts options ONCE?

thanks
David

[MAK]

If you are scripting from Query analyser you can save all the settings.

Open object browser in Query analyser.

right click on the object (eg: table) - scripting option.

[DLu]

thanks MAK.
I usually go through the E.M. interface to generate the script, where there is an options tab to click index, pk, default boxes, and default are blank.

Interesting to see that in sqlQuery, the table script option does not have pk, index, default but with many formating options. And the sqlQuery side script generated with pk, constraint and default already, no options for them to be y/n.

-D