Maintenance of index using ALTER INDEX

If you are having a problem using Vault, post a message here.

Moderator: SourceGear

Post Reply
hwapdc
Posts: 35
Joined: Thu Dec 09, 2010 6:11 am

Maintenance of index using ALTER INDEX

Post by hwapdc » Mon Mar 18, 2013 9:42 am

The scripts in maintenance articles:
* http://support.sourcegear.com/viewtopic.php?t=2924
* http://support.sourcegear.com/viewtopic ... 13&t=21402

uses DBCC DBREINDEX and INDEXDEFRAG

According to http://msdn.microsoft.com/en-us/library/ms143729.aspx these are deprecated in
SQL Server 2012.
Could you please provide scripts using ALTER INDEX?
Kind regards, hwapdc

Beth
Posts: 8550
Joined: Wed Jun 21, 2006 8:24 pm
Location: SourceGear
Contact:

Re: Maintenance of index using ALTER INDEX

Post by Beth » Mon Mar 18, 2013 2:08 pm

I've put in a request to get this updated. Thank you for pointing out the changes.

F: 16809
Beth Kieler
SourceGear Technical Support

Post Reply