Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
In following cases you will need to generate a scripts for all the clustered and non-clustered indexes on the SQL Server 2005 database:
1. During heavy bulk inserts into a table, you might want to drop all the indexes on the table to make the bulk load process go faster. Once the bulk load is done you can re-create those indexes back using the scripts.
2. If all the clustered and non-clustered indexes are built on a one single filegroup (PRIMARY, for example) and if you would like to move them to an appropriate filegroup (_DATA and _IDX, for example), you would need both create and drop scripts for clustered and non-clustered indexes.
There is a way to achieve that. You can download a utility called DBScript from below website:
https://www.codeplex.com/SQLSrvScrpt/Wiki/View.aspx?title=DBScript%20Utility&referringTitle=Home
This utility will help you script clustered, non-clustered indexes, foreign keys, and triggers - both CREATE and DROP.