Jan 18 '12 at 03:49 AM
Jan 19 '12 at 02:45 AM
Jan 18 '12 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
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.
There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.
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 '12 at 03:49 AM
Seen: 898 times
Last Updated: Jan 19 '12 at 02:45 AM
list of sql jobs on the server
2005 SQL Server Linked Server Update - Runs Endlessly
Cross tab data required
install ...sql server 2012
SQL for duplicating parent and children records
Is there any alternative for like operators - for searching data
Regarding particular table and index sizes,rowcounts?
While reorganising the index for few indexs the defragmentation decraeses by 80%
Load Excel/Delimited files as tables in SQL server