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
 Old Forums
 CLOSED - General SQL Server
 FCB

Author  Topic 

cbeganesh
Posting Yak Master

105 Posts

Posted - 2004-05-13 : 13:37:25
Im getting this error when i run a select into query
Could not open FCB for invalid file ID 13618 in database

Anyone has any idea

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-05-13 : 13:41:10
That's not good. Run DBCC CHECKDB to see if you have corruption in the database. If DBCC CHECKDB returns any errors, note the ID of the object, then try to fix that.

Also, are you running service pack 3a for SQL Server 2000? If not:

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q276043

Tara
Go to Top of Page

cbeganesh
Posting Yak Master

105 Posts

Posted - 2004-05-13 : 13:48:08
i will check it out

thanks
gan
Go to Top of Page

JohnDeere
Posting Yak Master

191 Posts

Posted - 2004-05-13 : 17:42:42
Check the sql server error logs and see if they contain any additional information.


Lance Harra
Go to Top of Page
   

- Advertisement -