Jan 18, 2012 at 03:49 AM
Jan 19, 2012 at 02:45 AM
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
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, 2012 at 03:49 AM
Seen: 1022 times
Last Updated: Jan 19, 2012 at 02:45 AM
T-SQL Linked Server Query to Stop a JOB and Start it again
Split string based on a pattern
Regarding particular table and index sizes,rowcounts?
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
MSDB Permission SQLOperatorRole