Is there a script that I can use to activate and deactivate Indexes on a table
Jan 18, 2012 at 03:49 AM
Jan 19, 2012 at 02:45 AM
alter index [indexname] on [tablename] disable
Jan 18, 2012 at 04:13 AM
Wilfred van Dijk
This mabe a silly question but how would I enable it again.
I assume you change the disable to enable like below but then I get a sytax error
alter index [indexname] on [tablename] enable
You need to Rebuild the index, to enable it again. Please see BOL for more help.
Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.
Once you sign in you will be able to subscribe for any updates here
Answers and Comments
Need long-form SQL discussion? SQLserverCentral.com is the place.
asked: Jan 18, 2012 at 03:49 AM
Seen: 1328 times
Last Updated: Jan 19, 2012 at 02:45 AM
SQL Server update statistics
Split string based on a pattern
list of sql jobs on the server
SQL for duplicating parent and children records
Indexes on SQL Server
Regarding particular table and index sizes,rowcounts?
2005 SQL Server Linked Server Update - Runs Endlessly
Cross tab data required
install ...sql server 2012
MSDB Permission SQLOperatorRole