June 9, 2009 at 1:03 am
hi all, i created a non clustered index on a table in SSMS. when i try to delete it in SSMS it just reappears after i refresh the table... can someone please explain this to me cos im totally confused now...
June 9, 2009 at 1:35 am
the reason why im trying to delete this index is cos our application is throwing this error in our logs...
09-Jun-2009 06:53:48 [TP-Processor31] [ERROR] [DatabaseResult] Failed to close DatabaseResult java.sql.SQLException: The operation failed because an index or statistics with name 'idx_rel_id' already exists on table 'dbo.EntityRelationship'.
June 9, 2009 at 5:14 am
Can you please post the T-SQL statement you are issueing in order to drop the index.
June 9, 2009 at 6:36 am
It sounds like something in your code is trying to create the index, probably over & over again. You should check the code. I don't think you're dropping it is likely to help. I say this because you're getting a java error that says the index exists. This would only happen if the create call was coming from the java app.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 9, 2009 at 6:40 am
found the problem earlier, a script released to the environment didn't have a GO or END statement. Script contained an alter proc as well as a create index, so the index creation was interpreted as part of the proc....
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply