Skip to content

Instantly share code, notes, and snippets.

@65

65/cleanupindex.sql

Created March 5, 2012 09:10
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save 65/1977578 to your computer and use it in GitHub Desktop.
Save 65/1977578 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
cleanupindex.sql
sp_fulltext_catalog 'SearchIndexName', 'drop'
go
sp_fulltext_service 'clean_up'
go
Raw
dropindex.sql
sp_fulltext_table 'TableName', 'drop'
Raw
getcatalog.sql
SELECT *
FROM sysobjects
WHERE ftcatid IN (SELECT ftcatid FROM sysfulltextcatalogs)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment