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 |
|
tocroi72
Yak Posting Veteran
89 Posts |
 Posted - 2005-11-03 : 10:28:41
|
| hi,I am running this :dbcc showcontig (EMPLOYEE_EXTRACT)i got error below: Server: Msg 2501, Level 16, State 45, Line 1Could not find a table or object named 'EMPLOYEE_EXTRACT'. Check sysobjects.DBCC execution completed. If DBCC printed error messages, contact your system administrator.Then i look for that table name in sysobjects table it return me a record with that nameselect [name] from sysobjects where [name] ='EMPLOYEE_EXTRACT'what is the problem here? - Any idea would be greatly appreciated.I run dbcc showcontig on other table , it runs fine.Thanks |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
tocroi72
Yak Posting Veteran
89 Posts |
Posted - 2005-11-03 : 11:29:54
|
| Thank Brett for reminding me run the DBCC checkdb, however i got no error running that either. "CHECKDB found 0 allocation errors and 0 consistency errors in database 'TEST'.DBCC execution completed. If DBCC printed error messages, contact your system administrator. |
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
Question about DBCC SHOWCONTIG