HomeSQL ServerSQL Server does not script indexes by default

Comments

SQL Server does not script indexes by default — 12 Comments

  1. What about the Tasks / Generate Scripts option. That gives you a lot more flexibility with advanced options that you can have the tool do for you when generating the output for the objects you select.

  2. That section is not visible under my list of options. Any idea why not? Is this something that has to be set on the machine which is running the server? I’m running SSMS from a client machine, and not the machine that actually has the server installed on it.

  3. Is there a way to permanently change the default for ‘indexes’ to True? It is really stupid to make it False by default and updating the same values over and over is getting really tiresome. I would also permanently script triggers as well.

    • Michele, this appears to be settings located in SQL Studio Management Studio and not on the database itself. So, you’ll have to set this for every SSMS install that you need this functionality to exist on. If there’s a way to script the SSMS install to set these options, I’m unaware of a way to do so.

  4. Pingback:Just notes… » Blog Archive » SSMS erzeugt für Tabellenskript keine Indizes

Leave a Reply

Your email address will not be published. Required fields are marked *

HTML tags allowed in your comment: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>