Tuesday, December 8, 2015

Got Error: Invalid object name 'master.dbo.spt_values'

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.

goto the location "C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Install".
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.

1 comment:

  1. Nothing Is Bug …: Got Error: Invalid Object Name 'Master.Dbo.Spt_Values' >>>>> Download Now

    >>>>> Download Full

    Nothing Is Bug …: Got Error: Invalid Object Name 'Master.Dbo.Spt_Values' >>>>> Download LINK

    >>>>> Download Now

    Nothing Is Bug …: Got Error: Invalid Object Name 'Master.Dbo.Spt_Values' >>>>> Download Full

    >>>>> Download LINK

    ReplyDelete