We help IT Professionals succeed at work.

index rebuild failed

wasabi3689
wasabi3689 asked
on
I have index rebuild procedure failed. I have the following error. The failed run into this line then stop
Msg 1088, Level 16, State 9, Line 1
Cannot find the object "ABC_Staging.dbo.primed/mxc10288.enrollcoverage" because it does not exist or you do not have permissions.

Open in new window


The problem is I don't find this object. How come it keep failing into this line?

How to fix it
Comment
Watch Question

View Solution Only

Satish ValekarSr. DBA

Commented:
Drop the rebuild procedure and create it again and checked it.

Execute procedure by giving full qualified name "Database.DBO.storeprocname"
Jason clarkDBA Freelancer

Commented:
Dropping the sproc and recreating can fix your prblem or an internal table used by Change Tracking, and you cannot access this table unless you are connected on the Admin connection.
Vitor MontalvãoIT Engineer
Distinguished Expert 2017

Commented:
I have index rebuild procedure failed.
Can you explain how is the procedure?
Nakul VachhrajaniSenior Manager

Commented:
I wonder if it's the presence of a slash (/) in the object name that is the problem.

Should "ABC_Staging.dbo.primed/mxc10288.enrollcoverage" actually be "[ABC_Staging].[dbo].[primed/mxc10288].[enrollcoverage]", i.e. is the table name [primed/mxc10288]?
wasabi3689

Author

Commented:
[primed/mxc10288].[enrollcoverage] is the table name.
Vitor MontalvãoIT Engineer
Distinguished Expert 2017

Commented:
So, why do you need the dbo part in the table name?
The correct name to use should be: ABC_Staging.[primed/mxc10288].enrollcoverage
Senior Manager
Commented:
I agree. If [primed/mxc102888] is the schema, the [dbo] does not make sense. The 4-part naming convention is: [instance name].[database name].[schema name].[table/object name]

In your case, you only need [database name].[schema name].[table/object name] - where does the [dbo] come in?
Vitor MontalvãoIT Engineer
Distinguished Expert 2017

Commented:
wasabi, what's the difference from Nakul's comment and mine?