Wednesday, March 7, 2012

Find fulltext index is exist are not

Hi,
How to find full text index is exist in the table or not ?
like that how to find normal index is exist in the table or not ?
Thanks in adv.
--> Murali <--
get the name(s) of your catalog(s) from
select name from sysfulltextcatalogs
and then do this
sp_help_fulltext_tables 'CatalogName'
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
<murali.ipr@.gmail.com> wrote in message
news:1137561588.657050.127870@.o13g2000cwo.googlegr oups.com...
> Hi,
> How to find full text index is exist in the table or not ?
> like that how to find normal index is exist in the table or not ?
> Thanks in adv.
> --> Murali <--
>
|||Thankyou Hilry Cotter

No comments:

Post a Comment