I want to disable index and rebuild indexes.
ALTER INDEX PK_Employee_EmployeeID ON HumanResources.Employee
This works fine in SQL 2005, but I have one instance in SQL2000. Can you please let me know equivalent in SQL 2000. It gives Incorrect syntax near the keyword 'index' in SQL2000