[dba-SQLServer] Adding indexes programmatically

Take a look at the SQL-DMO library. It's got everything you need in it. 
Walk the databases, the tables, the columns and the properties, all in a 
pretty cool (IMO) object model.

John W. Colby wrote:

>Does anyone have code to add indexes to every field in a table?  I am
>breaking the nVLDB table down into subsets of related fields in smaller
>tables and need to index each field.  The PK field is just that, an integer
>and unique.  The rest are just text fields and non-unique.
>
>John W. Colby
>www.ColbyConsulting.com 
>
>
>  
>


-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.296 / Virus Database: 265.5.0 - Release Date: 12/9/2004