Tuesday, 20 March 2012

Invalid object name 'master.dbo.spt_values'

You might have found this unusual error when trying to right-click a database in SQL Server Management Studio (to get properties etc). It is caused by tables that have been deleted from the master database, which can be caused by various inerrant processes!
Anyway, to fix it, run u_tables.sql from the install directory of your SQL server instance and this will recreate most of the tables you need and get you back up and running.
Post a Comment