Sorry, did you try combining them with Or like you were doing on your code?
Otherwise, you could generate the drop script first and then the default.
HTH
>Thanks for your answer but it doesn't work! it add the 2 options
>
>lOptions1 = SQLDMOScript_Default + SQLDMOScript_Drops
>it gives : lOptions1= 4 + 1
>so lOptions1 = 5 and it's not the right option!
>
>when i tried them separately it works!
>with the option SQLDMOScript_Default, it scripts the indexes for the table
>with the option SQLDMOScript_Drops, it drops the indexes from the table
>
>but i need them in one script like :
>
>If indexA exists drop
>create indexA
> select * from table1
>
>if indexB exists drop
>create indexB
> select * from table2
>...
>
>you know what i mean?
>
>thanks for your time!
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only