For those interested, problem was an outdated MDAC on the server.  When I installed the latest version that the OS could take, I was then able to install SQL 2000...

Looks like I figured it out.  When I first deleted all the indexes on the Ticket table, then issued the delete query, it worked!

I can now rebuild all the indexes.

Thanks...

Getting close, but it is still fighting me.... since it's just one ticket, we can just kill the rows and re-enter the ticket from the app, so I am trying to...

I will give it a shot.

Thanks!

- JB

Ok, I think I get it now.

I issued "select TicketID from Ticket group by TicketID having count(*) > 1"

and this came back with

TicketID   

-----------

301068226

as a result.  I am assuming...

I think I get it, but maybe need a little more info....

Since the key for this index is TicketID for the Ticket table, I tried the query:

select * from Ticket

group by...