Disable Index

Last Post 05 Aug 2009 09:09 AM by sql-tips. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
sql-tips
New Member
New Member

--
03 Aug 2009 11:24 AM
I want to disable index and rebuild indexes.

USE AdventureWorks;
GO
ALTER INDEX PK_Employee_EmployeeID ON HumanResources.Employee
DISABLE;
GO

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
sql-tips
New Member
New Member

--
05 Aug 2009 09:09 AM
For long running inserts, Just want to disable index and re build it after insertion. Thanks for your info.


Acceptable Use Policy
---