Data Scripter Utility for SSMS

You can generate a script for a data within a table – whole bunch of insert statement.   There is an external plug-in available at http://www.codeproject.com/useritems/enisey.asp.   I downloaded it and installed it on my machine, it works great.   After installing it you will see an option in your SSMS within Right-click menu off of a selected table…

2

Generating Scripts only for Clustered and Non-Clustered indexes in SQL Server 2005

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…

0