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 |
|
mahajanakhil1985
Yak Posting Veteran
71 Posts |
 Posted - 2010-05-20 : 10:25:37
|
| I am facing below error while rebuilding all indexes on a table:use qpsalter index all on qpp_article_components rebuild with (fillfactor=90)Msg 1088, Level 16, State 9, Line 2Cannot find the object "qpp_article_components" because it does not exist or you do not have permissions.The object exists as a table. For permissions, I have logged in as 'sa' user and still see the same error. |
|
|
mahajanakhil1985
Yak Posting Veteran
71 Posts |
Posted - 2010-05-20 : 10:27:26
|
| But I am able to rebuild individual indexes without any problem. |
 |
|
|
mahajanakhil1985
Yak Posting Veteran
71 Posts |
Posted - 2010-05-21 : 07:49:46
|
| any updates on this? |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-05-21 : 10:24:12
|
| Table owned by a schema that is NOT "dbo"? |
|
|
|
mahajanakhil1985
Yak Posting Veteran
71 Posts |
Posted - 2010-05-24 : 06:35:59
|
| Thanks! A fundamental mistake. I just didn't see it if I am logged in as a right login whose default user is mapped to right schema. |
|
|
|
|
|
|
not able to rebuild index