Fordraiders
asked on
sql server express 2008 : Deleting data in table with Full-Text Indexes
sqlexp2008
I have created a table with some test data. Also created a Primary Index. A Full-text catalog plus a full-text index successfully.
Question:
I used the TRUNCATE to delete my Data.
I think this also deleted any indexes and full catalog indexes and catalogs.
What is the best method to preserve my indexes and Full-text catalog and indexes. Because I will be deleting and importing data alot ?
Thanks
fordraiders
I have created a table with some test data. Also created a Primary Index. A Full-text catalog plus a full-text index successfully.
Question:
I used the TRUNCATE to delete my Data.
I think this also deleted any indexes and full catalog indexes and catalogs.
What is the best method to preserve my indexes and Full-text catalog and indexes. Because I will be deleting and importing data alot ?
Thanks
fordraiders
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.