>Hi,
>
>To create an index from VFP application I can execute the following script:
>
>
>CREATE NONCLUSTERED INDEX [MyIndex]
>ON [dbo].[tablename] ([rec_id])
>
>
>However, when I create an index script in SSMS the script includes the following:
>
>
>CREATE NONCLUSTERED INDEX [MyIndex] ON [dbo].[tablename]
>(
> [MyIndex] ASC
>)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
>
>
>My question is, do I need (is it necessary) to add the ASC and the line WITH.. with all the settings when creating an index from VFP?
Unless you want to change any of the default settings, you don't need to add them to create index script.
If it's not broken, fix it until it is.
My Blog