|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
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
|
||||
|
||||
|
How did you export? To .sql file?
|
|
#3
|
|||
|
|||
|
I used .. export import utility.
|
|
#4
|
||||
|
||||
|
I'd rebuild the structure through a .sql file (hand checked!!) and then populate it with that tool.
|
![]() |
| Viewing: Dev Shed Forums > Databases > MS SQL Development > No Indexes Exported |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|