Post reply

SSMS Index Scripting

  • October 21, 2008 at 3:32 pm

    #125604

    We have several indexes that have include clauses. When you script out that index (and yes I have scripting set to version 2005) the include clause is left out. Does anyone know if this is a bug or if there is a way around this?

    Thanks

  • October 21, 2008 at 3:41 pm

    #887859

    I know that when I right click on an index and select script to new query window I get the include columns as well as the standard referenced columns. Is that the way you are scripting them?

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • October 21, 2008 at 3:49 pm

    #887862

    I just created a test and it did script the include, but when I have applied index recommendations from the DB Tuning Advicor and then scripted them out, the include caluse did not script out for some reason

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

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