Showing posts with label adv. Show all posts
Showing posts with label adv. Show all posts

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