Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problem with Table - Diagnosis Needed
Message
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Titre:
Problem with Table - Diagnosis Needed
Divers
Thread ID:
00646105
Message ID:
00646105
Vues:
47
Yesterday, I had a stored procedure that whenever it was exec, it would lockup the VFP application. The SQL server perfMon was show 0-1 CPU utilization. I opened each table the stored procedure uses in the enterprise manager, and everything looked ok. I finally restored it from the backup (from the day before) and everything worked fine. Today, it did it again, same SP locks the application and the server doesn't appear to be doing anything. I went into Enterprise Manager and went to add an index on the table I thought might be a problem (meetproc) and when I clicked the save, it just basicly froze. I did a ctrl/Alt/Del and killed enterprise manager. When back into the application, it works fine. Opened up enterprise manager, the new index wasn't there. I went through the add process again, it worked fine. So then I decided to rebuild the indexes on the table. I went into Query Analyzer and ran: dbcc dbreindex('meetproc')
It produced the following output:
Server: Msg 169, Level 15, State 2, Line 2
A column has been specified more than once in the order by list. Columns in the order by list must be unique.
Server: Msg 169, Level 15, State 1, Line 2
A column has been specified more than once in the order by list. Columns in the order by list must be unique.
Server: Msg 169, Level 15, State 1, Line 2
A column has been specified more than once in the order by list. Columns in the order by list must be unique.
Server: Msg 169, Level 15, State 1, Line 2
A column has been specified more than once in the order by list. Columns in the order by list must be unique.
Server: Msg 169, Level 15, State 1, Line 2
A column has been specified more than once in the order by list. Columns in the order by list must be unique.
Server: Msg 169, Level 15, State 1, Line 2
A column has been specified more than once in the order by list. Columns in the order by list must be unique.
Server: Msg 169, Level 15, State 1, Line 2
A column has been specified more than once in the order by list. Columns in the order by list must be unique.
Server: Msg 169, Level 15, State 1, Line 2
A column has been specified more than once in the order by list. Columns in the order by list must be unique.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Anybody have any clues what might be going on?

UPDATE:
New twist, I do believe it is an index problem. I decided to go delete all the indexes. I got to one labeled dbo.meetproc.meetproc9 which is a clustered index. I'm sure the index wizard built this based off the name. Anyway, I went to delete it, and received the following error:
Server: msg 3703, Level 11, State 7
Cannot drop the index 'dbo.meetproc.meetproc9', because it does not exist in the system catalog.
Thanks in advance

Kirk
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform