We have SQL2012 SP1 installed on several servers and have run into an issue on one instance trying to view the database properties in SSMS. (This happens with both SSMS 11.0.5058.0 and 11.0.3128.0.) I have crawled all over Google results looking for something that makes sense, but I'm baffled at the moment.
The issue is rooted with a view in the master database called
dbo.spt_values. This table is referenced in the error thrown by SSMS when trying to view the properties.
The recommended solution here is to run the
u_tables.sql script with will recreate the necessary objects in the master database. Opening and running this script produces an error stating:
Msg 208, Level 16, State 1, Procedure spt_values, Line 7 Invalid object name 'sys.spt_values'.
Most of the posts I have seen related to this error recommend completely rebuilding the master database at this point, then reattaching or restoring the user databases. Before I went down this road, I wanted to see what the servers not experiencing this problem look like... To further my befuddlement, I am not able to see
sys.spt_values ON ANY INSTANCE OR ANY DATABASE. However, the
master.dbo.spt_values view does return rows when queried. When I try to take the select statement out of the view and run it, I get the invalid object message again.
I have connected as my windowd users, which is sysadmin, as well as the SA login. I have done this on each of the servers as well as a local instance of SQL 2012 SP2. I have used SSMS installed with the original SP1 installation as well as an instance that had been upgraded to SP2.
I have also looked at synonyms, other views, functions, stored procedures, or any other objects I could parse or query and have no idea where I can find the
sys.spt_values table. Any help to get the properties box working as well as improve my understanding of the purpose of this table and where it lives would be monumentally helpful!
Resources I've already looked at:
(I also followed links within the links... Good thing I'm bald already)