Post reply

How to get the size of Full-Text Catalog?

  • November 25, 2008 at 12:41 am

    #196218

    I create a Full-Text catalog, now I want to get its size, but I don't know how.

    Could

    And is it same for SQL2005 and SQL 2008?

  • November 25, 2008 at 8:46 am

    #903196

    I think it's similar in 2005 and 2008

    In SSMS

    Database -> Storage -> Full Text Catalogs -> right-click on the catalog -> Catalog size (also shows you # of rows)

    For example, my AdventureWorks2008 "AW2008FullTextCatalog" catalog is only 0MB with little data full-text'ed

    SQLServerNewbieMCITP: Database Administrator SQL Server 2005

  • November 26, 2008 at 6:34 am

    #903678

    Thx for reply. Sorry, I didn't describe clearly. You misunderstood my words. I want to get full-text catalog size by T-SQL statement, how can I do this?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply