Home Forums SQL Server 2005 T-SQL (SS2K5) Adding an include to an existing Index RE: Adding an include to an existing Index

  • May 23, 2013 at 7:58 am

    #1617870

    You will have to drop the existing index and then create the index with the INCLUDED columns

    The link below can help you with the syntax to create the index with INCLUDED columns

    http://msdn.microsoft.com/en-us/library/ms190806%28v=sql.90%29.aspx

    Kingston Dhasian

    How to post data/code on a forum to get the best help - Jeff Moden
    http://www.sqlservercentral.com/articles/Best+Practices/61537/