Using DMO to script indexes that have INCLUDES columns

• Ben Marsh

  SSC Rookie

  Points: 37

  More actions

  March 8, 2010 at 11:02 am

  #96900

  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