Lesson Learned….. Scripting indexes is off by default in SQL Servers….
Technology Jan 23, 2014
While doing a data refresh last night for a project I am working on at the moment, I generate the database scripting thinking the indexes will come with the script, but it doesn’t and the database failed to populate due to performance issues…
To resolve the problem I have to go to the options in the SQL Management Studio, and under SQL Server Object Explorer, Scripting, and set Script Indexes and Script Triggers to “ON“…
Lesson learned…..