|
|
|
SSChasing Mays
 
Group: General Forum Members
Last Login: Friday, October 16, 2009 2:35 PM
Points: 698,
Visits: 189
|
|
|
|
|
|
SSC Journeyman
Group: General Forum Members
Last Login: Yesterday @ 6:41 AM
Points: 78,
Visits: 101
|
|
Nice script.
Might this
'CREATE NONCLUSTERED INDEX IX__' + parentschemas.name + '_' + parentobjects.name + '__' + REPLACE(foreign_key_columns.foreign_key_columns, ', ', '_') + ' ON ' + parentschemas.name + '.' + parentobjects.name + ' (' + foreign_key_columns.foreign_key_columns + ')' AS FKIndexCreate
be this
'CREATE NONCLUSTERED INDEX IX__' + parentschemas.name + '_' + parentobjects.name + '__' + REPLACE(foreign_key_columns.foreign_key_columns, ',', '') + ' ON ' + parentschemas.name + '.' + parentobjects.name + ' (' + REPLACE( foreign_key_columns.foreign_key_columns, ',', '' ) + ')' AS FKIndexCreate
Great Job, As Usual,
Doug
|
|
|
|
