October 27th, 2003, 09:13 AM
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?
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 : firstname.lastname@example.org
October 27th, 2003, 09:16 AM
How did you export? To .sql file?
October 27th, 2003, 09:28 AM
I used .. export import utility.
October 27th, 2003, 11:01 AM
I'd rebuild the structure through a .sql file (hand checked!!) and then populate it with that tool.