index rebuild failed

wasabi3689
wasabi3689 used Ask the Experts™
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

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
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ãoMSSQL Senior Engineer
Distinguished Expert 2017

Commented:
I have index rebuild procedure failed.
Can you explain how is the procedure?
Should you be charging more for IT Services?

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Find out now!
Nakul VachhrajaniTechnical Architect, Capgemini India

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ãoMSSQL Senior 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
Technical Architect, Capgemini India
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ãoMSSQL Senior Engineer
Distinguished Expert 2017

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

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial