declare @fileGroup sysname
set @fileGroup = 'CrawlFileGroup'

if not exists (select 1 from sys.filegroups where name = @fileGroup)
begin
	raiserror ('The specified filegroup does not exist.', 16, 1)
	return
end

exec proc_MoveTableToFileGroup @fileGroup, 'MSSAnchorChangeLog'

exec proc_MoveTableToFileGroup @fileGroup, 'MSSAnchorPendingChangeLog'

exec proc_MoveTableToFileGroup @fileGroup, 'MSSAnchorText'

exec proc_MoveTableToFileGroup @fileGroup, 'MSSAnchorTransactions'

exec proc_MoveTableToFileGroup @fileGroup, 'MSSCrawlChangedSourceDocs'

exec proc_MoveTableToFileGroup @fileGroup, 'MSSCrawlChangedTargetDocs'

exec proc_MoveTableToFileGroup @fileGroup, 'MSSCrawlContent'

exec proc_MoveTableToFileGroup @fileGroup, 'MSSCrawlDeletedErrorList'

exec proc_MoveTableToFileGroup @fileGroup, 'MSSCrawlDeletedURL'

exec proc_MoveTableToFileGroup @fileGroup, 'MSSCrawlErrorList'

begin try
	begin tran
	IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_MSSCrawlContent_MSSCrawlHistory]') AND parent_object_id = OBJECT_ID(N'[dbo].[MSSCrawlContent]'))
	ALTER TABLE [dbo].[MSSCrawlContent] DROP CONSTRAINT [FK_MSSCrawlContent_MSSCrawlHistory]

	exec proc_MoveTableToFileGroup @fileGroup, 'MSSCrawlHistory'

	ALTER TABLE [dbo].[MSSCrawlContent]  WITH CHECK ADD  CONSTRAINT [FK_MSSCrawlContent_MSSCrawlHistory] FOREIGN KEY([CrawlID])
	REFERENCES [dbo].[MSSCrawlHistory] ([CrawlID])

	commit
end try
begin catch 
	rollback
end catch

exec proc_MoveTableToFileGroup @fileGroup, 'MSSCrawlHostList'

exec proc_MoveTableToFileGroup @fileGroup, 'MSSCrawlQueue'

exec proc_MoveTableToFileGroup @fileGroup, 'MSSCrawlURL'

exec proc_MoveTableToFileGroup @fileGroup, 'MSSCrawlURLLog'

exec proc_MoveTableToFileGroup @fileGroup, 'MSSTranTempTable0'