sql server express 2008 :  Deleting data in table with Full-Text Indexes

Posted on 2009-12-18
Last Modified: 2012-05-11

I have created a table with some test data. Also created a Primary Index. A Full-text catalog plus a full-text index successfully.

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 ?


Question by:fordraiders
    LVL 75

    Accepted Solution

    The truncate table actually dropes and recreate the table, eventhough it deletes, for sure it will create the indexes, but since the table is empty, there wont be any use for those empty indexes
    LVL 142

    Assisted Solution

    by:Guy Hengel [angelIII / a3]
    >What is the best method to preserve my indexes and Full-text catalog and indexes.
    the indexes will still be present, but empty.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    SQL help 5 42
    How to run sql statements from SQLCMD or command line 2 33
    indexed table vs unindexed table 19 48
         When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
    Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now