Henrik Staun Poulsen at Baader HenrikSPoulsenBaader
dalenewman
/ gist:6377911
Last active
August 16, 2023 15:08
A T-SQL stored procedure for moving an index from one file group to another. The original script was found at http://blogs.msdn.com/b/ramoji/archive/2008/09/26/how-to-move-existing-indexes-from-one-filegroup-to-another.aspx and updated according to responses found on the same page.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[MoveIndexToFileGroup]') AND type in (N'P', N'PC')) | |
| BEGIN | |
| DROP PROCEDURE [dbo].[MoveIndexToFileGroup] | |
| END | |
| GO | |
| CREATE PROC [dbo].[MoveIndexToFileGroup] ( | |
| @DBName sysname, | |
| @SchemaName sysname = 'dbo', | |
| @ObjectNameList Varchar(Max), |