September 18, 2008 at 6:45 am
Hopefully someone can help me. I am trying to run the following statement:
exec sp_autostats 'VBMOD'
the error that is being returned is the following:
Msg 15390, Level 11, State 1, Procedure sp_autostats, Line 46
Input name 'VBMOD' does not have a matching user table or indexed view in the current database.
When i go into the table summary i can see VBMOD.
Can anyone help me understand why this statement is not working???
Thanks in advance.
Em :ermm:
September 18, 2008 at 6:51 am
Are you sure that there is a table or index named VBMOD.
You need to pass a table name to sp_autostats.
"Keep Trying"
September 18, 2008 at 6:51 am
Is the table owned by dbo, or another user?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 18, 2008 at 6:51 am
If you are sure you are executing that in the database with that table then the other problem could be that the table is owned by someone other than dbo? See if that is the case.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 18, 2008 at 7:00 am
When i have looked in the table list for the database i can see this table that i am trying to run this against.
I have just notice that there is an extra layer to the data base. It seems to work now that i have found this out.
The table was owned by the DBO.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply