see also -- Blank "initial catalog" problem on OLEDB connection string of SQL Server Database
When you tried to view properties of a database in SQL Server, you got the error " Invalid object name 'master.dbo.spt_values' ". it is very common error, raised when one or more views are unavailable/deleted somehow from master database. Don't be panic for that. It's very simple to recover. Just run the below mentioned script to resolved it.
When you tried to view properties of a database in SQL Server, you got the error " Invalid object name 'master.dbo.spt_values' ". it is very common error, raised when one or more views are unavailable/deleted somehow from master database. Don't be panic for that. It's very simple to recover. Just run the below mentioned script to resolved it.
goto the location "C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\
where "C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER" is your SQL Server installation folder.
then run the script u_tables.sql file. it's done. now this error will be gone away.
