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.
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 queryCould not open FCB for invalid file ID 13618 in databaseAnyone 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;Q276043Tara |
|
|
cbeganesh
Posting Yak Master
105 Posts |
Posted - 2004-05-13 : 13:48:08
|
i will check it outthanksgan |
|
|
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 |
|
|
|
|
|