Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Spetty
Starting Member
25 Posts |
 Posted - 2007-01-03 : 18:06:13
|
| Looking for suggestions.I have a database that is giving me a bad Index error. When I go to drop the necessary Index it is telling me that it either does not exist or cannot be dropped. However when I try to build that index, it tells me one already exists. Is there any way to drop all of the indexes or at the very least see what the indexes are? This particular database is using 2005 Express.Any help would be great!Shawn |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2007-01-03 : 18:39:51
|
| reboot client computer.if that doesnt work, stop/re-start mssql service. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-01-03 : 18:46:50
|
| In case this is data corruption in the index, do not reboot the server where the database exists. First run DBCC CHECKDB(DBNameGoesHere) on the database. If everything is fine, post the code that you are using to drop the index. If you are using the GUI to drop the index, then try it through code via DROP INDEX...Tara Kizer |
|
|
|
Spetty
Starting Member
25 Posts |
Posted - 2007-01-03 : 18:51:25
|
| rebooting does not work. This was happening on the clients DB, then when moved over to my system, it has been rebooted several times.The attempt to drop index has been made via code using Drop Index giving the information above. Once I get back on the system with that database I will try the DBCC. |
|
|
|
Spetty
Starting Member
25 Posts |
Posted - 2007-01-06 : 10:22:49
|
| I was finally able to resolve the issue. Once I got management studio installed for 2005 Express I was able to look at the actual indexes built on my tables. The one in question was built with a different name than what it was supposed to be. Once I saw that I was able to drop that index and rebuild properly. |
|
|
|
|
|
|
Dropping All Indexes