Showing posts with label exist. Show all posts
Showing posts with label exist. 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

Sunday, February 19, 2012

filtering rows that already exist in the destination table

Hi All,

What is the most straighforward way of not importing rows that already exist in the destination table (as determined by a primary key value)? Thanks.

Regards,

Daniel

Method 2 here: http://www.sqlis.com/default.aspx?311

-Jamie

|||Excellent, thanks.