|
--script drop of full text indexes
insert into #sql (sql)
select 'DROP FULLTEXT INDEX ON ['+s.name+'].['+o.name+']' as [sql] from sys.fulltext_indexes i join sys.objects o on i.object_id = o.object_id join sys.schemas s on o.schema_id = s.schema_id
|
By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.
If a file you wish to view isn't highlighted, and is a text file (not binary), please
let us know and we'll add colourisation support for it.
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.