Due to large import function, I would like to disable my constraints.
The query I use is
ALTER INDEX ALL ON [table_name] Disable.
The disabling part runs successfully when I try to enable them it passes error:
Cannot find Index <index_name>
The command I use
ALTER INDEX ALL ON [table_name] Rebuild.
I even tried
ALTER INDEX <index_name> ON [table_name] Rebuild
ALTER INDEX <index_name> ON [schema_name].[table_name] Rebuild
But all fails.
When i query sysobjects and INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE the Fk constraint do exist there.
what is that I miss