Sql Error 307 - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Other Forums

SQL Server 6.5 \ SQL Server 7.0

Sql Error 307

Author

Topic

tadj
Starting Member

2 Posts

Posted - 2007-08-09 : 01:45:05

Hello All,

Could some one show me how to resolve this error,

Index ID %d on table '%.*ls' (specified in the FROM clause) does not exist.

so i use SQL Server 7.0

Please help

Many Thanks

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2007-08-09 : 02:19:14

show us your query. are you specifying an index with a hint?

-ec

tadj
Starting Member

2 Posts

Posted - 2007-08-09 : 06:23:24

Hi eyechart,

This is the full message :

" #307-index ID3 on table DOCSADM.A_TYP (Specified in The Form Clause)does not exist “

and prompt you to click “Yes or No” yes to see Sql query Statement

SELECT DOCSADM.A_PROJECT.PROJECT,DOCSADM.A_PROJECT.SYSTEM_ID FROM DOCSADM.A_PROJECT(2) ORDER BY DOCSADM.A_PROJECT.PROJECT

This PROJECT(2) Table dose not exist

Many Thanks
Hacene

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-08-09 : 23:38:22

Tried this?

SELECT DOCSADM.A_PROJECT.PROJECT,DOCSADM.A_PROJECT.SYSTEM_ID FROM DOCSADM.A_PROJECT ORDER BY DOCSADM.A_PROJECT.PROJECT

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources