Using DMO to script indexes that have INCLUDES columns

  • Hi,

    This is my first post so I hope I'm not asking something that has been covered many times before. I searched the forums but didn't find anything on this.

    We have been using SQL-DMO internally to create scripts for our database and its information to update our customers databases when we release an update for our software. This has been going very well until we added a few indexes that had used the INCLUDES ability.

    When I run the DMO script I pass it 73736 to make the indexes. All are created. The Same is below.

    Vars for below SAMPLE

    SQLDMOScript_Default=73736

    loObject= #theTablename

    SAMPLE

    SQLDMO.DBObject.Script(SQLDMOScript_Default, tcDestinationFolder + loObject.Name + ".sql")

    But the index script generated does not have the INCLUDES information.

    Does anyone know the SQL-DMO variable value to pass or add to the 73736 value to generate the includes?

    Thank you.

    Ben

Viewing 0 posts

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