Friday, March 9, 2012

non clustered index

Can anyone tell me why Enterprise manager-Generate SQL
scripts utility does not generate scripts for non
clustered index? Thanks.Because you didn't check "Script indexes" on the Options tab of the Generate
SQL Scripts dialog?
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Bill" <fei0405@.yahoo.com> wrote in message
news:0e3801c49cf5$0493c450$a501280a@.phx.gbl...
> Can anyone tell me why Enterprise manager-Generate SQL
> scripts utility does not generate scripts for non
> clustered index? Thanks.|||Or you missed it in the Alter Table section?
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:ekeFnbPnEHA.3996@.TK2MSFTNGP09.phx.gbl...
> Because you didn't check "Script indexes" on the Options tab of the
Generate
> SQL Scripts dialog?
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "Bill" <fei0405@.yahoo.com> wrote in message
> news:0e3801c49cf5$0493c450$a501280a@.phx.gbl...
> > Can anyone tell me why Enterprise manager-Generate SQL
> > scripts utility does not generate scripts for non
> > clustered index? Thanks.
>|||Thank you. I did checked "Script indexes" on the Options
tab. I don't see Alter Table section. Can you navigate me
a little bit? Thank you so much.
>--Original Message--
>Or you missed it in the Alter Table section?
>"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote
in message
>news:ekeFnbPnEHA.3996@.TK2MSFTNGP09.phx.gbl...
>> Because you didn't check "Script indexes" on the
Options tab of the
>Generate
>> SQL Scripts dialog?
>> --
>> http://www.aspfaq.com/
>> (Reverse address to reply.)
>>
>>
>> "Bill" <fei0405@.yahoo.com> wrote in message
>> news:0e3801c49cf5$0493c450$a501280a@.phx.gbl...
>> > Can anyone tell me why Enterprise manager-Generate SQL
>> > scripts utility does not generate scripts for non
>> > clustered index? Thanks.
>>
>
>.
>|||> Thank you. I did checked "Script indexes" on the Options
> tab.
Which index(es) are you expecting to get scripted? If they're the
system-generated ones (WA_SYS...) they won't be generated because these are
created by the system based on stats. If you're having a problem scripting
something you created, then show us how you created it and exactly what you
are doing that's failing.|||Make sure you have a non-clustered index. The best would be create one.
Then check by right clicking the table, All Tasks, Manage Indexes, look at
whether there is one with clustered as no.
Then right click the table, all tasks, generate sql script, option tab,
check the script indexes box.
"Bill" <anonymous@.discussions.microsoft.com> wrote in message
news:1bae01c49cf8$e65243f0$a301280a@.phx.gbl...
> Thank you. I did checked "Script indexes" on the Options
> tab. I don't see Alter Table section. Can you navigate me
> a little bit? Thank you so much.
> >--Original Message--
> >Or you missed it in the Alter Table section?
> >
> >"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote
> in message
> >news:ekeFnbPnEHA.3996@.TK2MSFTNGP09.phx.gbl...
> >> Because you didn't check "Script indexes" on the
> Options tab of the
> >Generate
> >> SQL Scripts dialog?
> >>
> >> --
> >> http://www.aspfaq.com/
> >> (Reverse address to reply.)
> >>
> >>
> >>
> >>
> >> "Bill" <fei0405@.yahoo.com> wrote in message
> >> news:0e3801c49cf5$0493c450$a501280a@.phx.gbl...
> >> > Can anyone tell me why Enterprise manager-Generate SQL
> >> > scripts utility does not generate scripts for non
> >> > clustered index? Thanks.
> >>
> >>
> >
> >
> >.
> >|||Thank you very much.
Following the steps in your first paragraph, I only got
the scrip on one UNIQUE CLUSTERED index:
CREATE UNIQUE CLUSTERED
INDEX [PS_RF_ATTR_INSP] ON [dbo].[PS_RF_ATTR_INSP]
([SETID], [INST_PROD_ID], [MARKET], [ATTRIBUTE_ID])
WITH
FILLFACTOR = 90
,DROP_EXISTING
ON [PRIMARY]
When I issue command "sp_helpindex PS_RF_ATTR_INSP
go" I got more nonclustered index names as below:
index_name index_description
index_keys
PS_RF_ATTR_INSP clustered, unique located on PRIMARY
SETID, INST_PROD_ID, MARKET,ATTRIBUTE_ID
index_name index_description
index_keys
PS0RF_INST_PROD nonclustered located on PRIMARY
BO_ID_CUST, SETID, INST_PROD_ID
PS1RF_INST_PROD nonclustered located on PRIMARY
BO_ID_CONTACT, SETID, INST_PROD_ID
... ...
How could I get the scripts for those nonclustered indexes
for the table?
>--Original Message--
>Make sure you have a non-clustered index. The best would
be create one.
>Then check by right clicking the table, All Tasks, Manage
Indexes, look at
>whether there is one with clustered as no.
>Then right click the table, all tasks, generate sql
script, option tab,
>check the script indexes box.
>"Bill" <anonymous@.discussions.microsoft.com> wrote in
message
>news:1bae01c49cf8$e65243f0$a301280a@.phx.gbl...
>> Thank you. I did checked "Script indexes" on the Options
>> tab. I don't see Alter Table section. Can you navigate
me
>> a little bit? Thank you so much.
>> >--Original Message--
>> >Or you missed it in the Alter Table section?
>> >
>> >"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote
>> in message
>> >news:ekeFnbPnEHA.3996@.TK2MSFTNGP09.phx.gbl...
>> >> Because you didn't check "Script indexes" on the
>> Options tab of the
>> >Generate
>> >> SQL Scripts dialog?
>> >>
>> >> --
>> >> http://www.aspfaq.com/
>> >> (Reverse address to reply.)
>> >>
>> >>
>> >>
>> >>
>> >> "Bill" <fei0405@.yahoo.com> wrote in message
>> >> news:0e3801c49cf5$0493c450$a501280a@.phx.gbl...
>> >> > Can anyone tell me why Enterprise manager-Generate
SQL
>> >> > scripts utility does not generate scripts for non
>> >> > clustered index? Thanks.
>> >>
>> >>
>> >
>> >
>> >.
>> >
>
>.
>

No comments:

Post a Comment