Disable Index

Last Post 05 Aug 2009 10:09 AM by sql-tips. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
sql-tips
New Member
New Member

--
03 Aug 2009 12:24 PM
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 10:09 AM
For long running inserts, Just want to disable index and re build it after insertion. Thanks for your info.
You are not authorized to post a reply.

Acceptable Use Policy