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