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 |
|
amy
Starting Member
30 Posts |
 Posted - 2002-04-30 : 17:05:29
|
| dbcc dbreindex (BottleOrders, '', 70)I have the table BottleOrders and I try to ran this script but then I got the error "Could not find table named 'BottleOrders'. Check sysobjects", Any idea why?Thanks |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-04-30 : 17:28:10
|
It could be that the BottleOrders table was not created by the database owner (dbo), and you would have to include the owner's name as well as the table name:DBCC DBREINDEX ('owner.BottleOrders', '', 70)Or, you might need to specify dbo explicitly:DBCC DBREINDEX ('dbo.BottleOrders', '', 70)Not to mention that you must be in the correct database when you run DBREINDEX.  |
 |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-04-30 : 17:28:26
|
| Two ideas:1) Put the table name in single quotes like 'BottleOrders'2) verify the owner name is dbo. If the owner is something else, then you'll need to use 'ownername.BottleOrders'Dang Snipers!Edited by - AjarnMark on 04/30/2002 17:28:53 |
|
|
|
amy
Starting Member
30 Posts |
Posted - 2002-04-30 : 17:38:20
|
Thanks, I am an administrator so I though I don't need to provide onwer name for the table in order to ran this script, any ways thanks a lotquote:
It could be that the BottleOrders table was not created by the database owner (dbo), and you would have to include the owner's name as well as the table name:DBCC DBREINDEX ('owner.BottleOrders', '', 70)Or, you might need to specify dbo explicitly:DBCC DBREINDEX ('dbo.BottleOrders', '', 70)Not to mention that you must be in the correct database when you run DBREINDEX.
|
|
|
|
|
|
|
|
|
DBCC