MAXNOP8

SQL Server, SSIS, powershell

Monday, March 11, 2013

List Tables associated with a fulltext catalog

SELECT t.name AS TableName, c.name AS [CatalogName]
FROM sys.tables t JOIN sys.fulltext_indexes i
ON t.object_id = i.object_id JOIN sys.fulltext_catalogs c
ON i.fulltext_catalog_id = c.fulltext_catalog_id
blog_table_FTCatalog
Posted by Christophe at 3:31 AM
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: Administration

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ►  2016 (1)
    • ►  January (1)
  • ►  2015 (4)
    • ►  December (2)
    • ►  November (1)
    • ►  October (1)
  • ►  2014 (8)
    • ►  August (3)
    • ►  July (1)
    • ►  May (1)
    • ►  March (1)
    • ►  February (1)
    • ►  January (1)
  • ▼  2013 (14)
    • ►  September (3)
    • ►  August (3)
    • ►  July (1)
    • ►  April (2)
    • ▼  March (5)
      • Search Arguments : impact on query plans
      • Join tip – Inner Joins when using ON and WHERE Clause
      • List All plans in the cache SQL Server 2008
      • Full-Text Thesaurus Files overview
      • List Tables associated with a fulltext catalog
  • ►  2012 (16)
    • ►  November (2)
    • ►  October (5)
    • ►  September (1)
    • ►  August (2)
    • ►  July (6)

About Me

Christophe
View my complete profile
Awesome Inc. theme. Powered by Blogger.