THANK YOU GUYS I HAVE FOUND THE COMMAND
ALTER INDEX INDEX_NAME ON TABLE_NAME DISABLE
> DEAR ALL
>
> I HAVE THIS UNIQUE NON CLUSTER INDEX THAT I NEED TO DISABLE, BEFORE I
> IMPORT THE DATA FROM ORACLE TO SQL, IN ORACLE WE SIMPLY USE THIS COMMAND
> TO DISABLE AN INDEX
> ALTER INDEX INDEX_NAME DISABLE;
> IS THERE ANY WAY TO DO IT IN SQL
>
> BEST REGARDS
>
>


MS Sql Server LazyDBA home page