Error message with Index

[Jim Zhong]

URGENT!!!!!
I am getting this error and cannot find out what is happening anywhere!!!

Server: Msg 7319, Level 16, State 1, Line 3
OLE DB provider 'SQLOLEDB' returned a 'NON-CLUSTERED and NOT INTEGRATED' index 'account_index' with bookmark ordinal 0.


This is a SQL7 with service pack 3.

Please help me on this issue.



Jim

[Phil McCormack]

Try DBCC checktable (tablename) on the table in question (assuming reasonably small table)

Drop & re-create the account_index


------------
Jim Zhong at 2/9/01 11:47:47 AM

URGENT!!!!!
I am getting this error and cannot find out what is happening anywhere!!!

Server: Msg 7319, Level 16, State 1, Line 3
OLE DB provider 'SQLOLEDB' returned a 'NON-CLUSTERED and NOT INTEGRATED' index 'account_index' with bookmark ordinal 0.


This is a SQL7 with service pack 3.

Please help me on this issue.



Jim

Thanks Phil. I have figured it out what happened. I did all DBCCs but no luck; then I find out it is related to linked server with OLEDB for SQl server. Under the option, the index as acess path was checked. As soon as I unchecked it, the problem went away.


Jim


------------
Phil McCormack at 2/9/01 3:39:07 PM

Try DBCC checktable (tablename) on the table in question (assuming reasonably small table)

Drop & re-create the account_index


------------
Jim Zhong at 2/9/01 11:47:47 AM

URGENT!!!!!
I am getting this error and cannot find out what is happening anywhere!!!

Server: Msg 7319, Level 16, State 1, Line 3
OLE DB provider 'SQLOLEDB' returned a 'NON-CLUSTERED and NOT INTEGRATED' index 'account_index' with bookmark ordinal 0.


This is a SQL7 with service pack 3.

Please help me on this issue.



Jim

Thanks Phil. I have figured it out what happened. I did all DBCCs but no luck; then I find out it is related to linked server with OLEDB for SQl server. Under the option, the index as acess path was checked. As soon as I unchecked it, the problem went away.


Jim


------------
Phil McCormack at 2/9/01 3:39:07 PM

Try DBCC checktable (tablename) on the table in question (assuming reasonably small table)

Drop & re-create the account_index


------------
Jim Zhong at 2/9/01 11:47:47 AM

URGENT!!!!!
I am getting this error and cannot find out what is happening anywhere!!!

Server: Msg 7319, Level 16, State 1, Line 3
OLE DB provider 'SQLOLEDB' returned a 'NON-CLUSTERED and NOT INTEGRATED' index 'account_index' with bookmark ordinal 0.


This is a SQL7 with service pack 3.

Please help me on this issue.



Jim