Post reply

finding all USER database Full Text Indexes?

  • May 12, 2008 at 5:49 pm

    #122327

    Guys I am finding it hard to find a script that does this for me, I want something that shows all full text indexs on ALL user databases rather then doing one by one.

    has anyone got something simple that will do this, or could they point me in the right direction?

    Thanks

  • May 12, 2008 at 10:01 pm

    #814213

    Start looking at sp_help_fulltext_tables and sp_msforeachdb. Something like:

    sp_msforeachdb 'use [?];exec sp_help_fulltext_tables'

    Note that sp_help_fulltext_tables is deprecated in SQL Server 2005, replaced with sys.fulltext_catalogs.


    Scott Duncan

    MARCUS. Why dost thou laugh? It fits not with this hour.
    TITUS. Why, I have not another tear to shed;
    --Titus Andronicus, William Shakespeare

  • May 12, 2008 at 10:54 pm

    #814222

    thanks scott, I am using SQL 05

    so I am using

    sp_msforeachdb 'use [?]exec sys.fulltext_catalogs'

    however I am getting

    The request for procedure 'fulltext_catalogs' failed because 'fulltext_catalogs' is a view object.

    If I try the pre SQL05 one sp_msforeachdb 'use [?];exec sp_help_fulltext_tables'

    I then get what seems to be better results.

    Now i need to work out a way to get the database name with the full text name (if thats at all possible)

  • May 14, 2008 at 7:07 pm

    #815584

    Like the error said, sys.fulltext_catalogs is a view, not a stored procedure. You cannot EXEC it, you have to SELECT from it.


    Scott Duncan

    MARCUS. Why dost thou laugh? It fits not with this hour.
    TITUS. Why, I have not another tear to shed;
    --Titus Andronicus, William Shakespeare

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

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