Fear not! To defend your business’ IT systems we’re going to shine a light on the seven most sinister terrors that haunt sysadmins. That way you can be sure there’s nothing in your stack waiting to go bump in the night.
index rebuild failed
I have index rebuild procedure failed. I have the following error. The failed run into this line then stop
The problem is I don't find this object. How come it keep failing into this line?
How to fix it
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.
The problem is I don't find this object. How come it keep failing into this line?
How to fix it
Who is Participating?
Experts Exchange Solution brought to you by
Enjoy your complimentary solution view.
Get every solution instantly with Premium.
Start your 7-day free trial.
I wear a lot of hats...
"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.
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.
I wonder if it's the presence of a slash (/) in the object name that is the problem.
Should "ABC_Staging.dbo.primed/mxc
Should "ABC_Staging.dbo.primed/mxc
So, why do you need the dbo part in the table name?
The correct name to use should be: ABC_Staging.[primed/mxc102
The correct name to use should be: ABC_Staging.[primed/mxc102
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?
In your case, you only need [database name].[schema name].[table/object name] - where does the [dbo] come in?
Experts Exchange Solution brought to you by
Your issues matter to us.
Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.
Start your 7-day free trialIt's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server
From novice to tech pro — start learning today.
Experts Exchange Solution brought to you by
Enjoy your complimentary solution view.
Get every solution instantly with Premium.
Start your 7-day free trial.
Execute procedure by giving full qualified name "Database.DBO.storeprocnam