#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2003
    Posts
    81
    Rep Power
    11

    No Indexes Exported


    We have exported MS Sql Database Table to database under a web database server from Local MS Sql Server 2000. After Exporting We Checked the indexes of the table but none showed. We are still able to query data. Where did the indexes go, and what should we do in case we need to add or modify an index?
    Rubal Jain
    Webspiders Interweb Pvt. Ltd. & Brainus Networks
    http://www.it2ecom.com | http://www.brainus.net
    Server Management | Dedicated Servers | Reseller Hosting
    Experienced, Qualified Techs | 24/7 Support Centers in India
    Helm Premium Partners | Email : sales@brainus.net
  2. #2
  3. Modding: Oracle MsSQL Firebird
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jun 2001
    Location
    Outside US
    Posts
    8,527
    Rep Power
    538
    How did you export? To .sql file?
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2003
    Posts
    81
    Rep Power
    11
    I used .. export import utility.
  6. #4
  7. Modding: Oracle MsSQL Firebird
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jun 2001
    Location
    Outside US
    Posts
    8,527
    Rep Power
    538
    I'd rebuild the structure through a .sql file (hand checked!!) and then populate it with that tool.

IMN logo majestic logo threadwatch logo seochat tools logo