Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with Table - Diagnosis Needed
Message
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Problem with Table - Diagnosis Needed
Miscellaneous
Thread ID:
00646105
Message ID:
00646105
Views:
46
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
Next
Reply
Map
View

Click here to load this message in the networking platform