Sunday, March 11, 2012

Cannot View Database Properties (Express 2005)

It's always great to run into problems on a Friday afternoon before a
holiday weekend, but here I am.
I'm not sure when this started happening, but if I try to get
properties on any of the databases on my SQL Server Express 2005 server
(using the Management Studio GUI), it fails with the following error:
--
TITLE: Microsoft SQL Server Management Studio Express
Cannot show requested dialog.
ADDITIONAL INFORMATION:
Cannot show requested dialog. (Microsoft.SqlServer.Express.SqlMgmt)
An exception occurred while executing a Transact-SQL statement or
batch. (Microsoft.SqlServer.Express.ConnectionInfo)
Invalid object name 'master.dbo.spt_values'. (Microsoft SQL Server,
Error: 208)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.2047&EvtSrc=MSSQLServer&EvtID=208&LinkId=20476
--
The help link, while not the slightest bit helpful, is at least polite
and apologetic:
--
We're sorry
There is no additional information about this issue in the Error and
Event Log Messages or Knowledge Base databases at this time. You can
use the links in the Support area to determine whether any additional
information might be available elsewhere.
--
Anyone have any clue what's going on? Where oh where is my spt_values
table?
Thanks very much,
-DanIt looks like this system table was accidentally deleted. Spt_values is a
strange beast because it's has type 'U' instead of the normal 'S' like most
system tables.
You'll need to restore or rebuild master from backup to get it back. I'm
not sure exactly what impact this missing table might have on a 2005
instance but it's probably better to fix it sooner than later.
--
Happy Holidays
Dan Guzman
SQL Server MVP
"Daniel Manes" <danthman@.cox.net> wrote in message
news:1166832805.577147.242380@.h40g2000cwb.googlegroups.com...
> It's always great to run into problems on a Friday afternoon before a
> holiday weekend, but here I am.
> I'm not sure when this started happening, but if I try to get
> properties on any of the databases on my SQL Server Express 2005 server
> (using the Management Studio GUI), it fails with the following error:
> --
> TITLE: Microsoft SQL Server Management Studio Express
> Cannot show requested dialog.
> ADDITIONAL INFORMATION:
> Cannot show requested dialog. (Microsoft.SqlServer.Express.SqlMgmt)
> An exception occurred while executing a Transact-SQL statement or
> batch. (Microsoft.SqlServer.Express.ConnectionInfo)
> Invalid object name 'master.dbo.spt_values'. (Microsoft SQL Server,
> Error: 208)
> For help, click:
> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.2047&EvtSrc=MSSQLServer&EvtID=208&LinkId=20476
> --
> The help link, while not the slightest bit helpful, is at least polite
> and apologetic:
> --
> We're sorry
> There is no additional information about this issue in the Error and
> Event Log Messages or Knowledge Base databases at this time. You can
> use the links in the Support area to determine whether any additional
> information might be available elsewhere.
> --
> Anyone have any clue what's going on? Where oh where is my spt_values
> table?
> Thanks very much,
> -Dan
>

No comments:

Post a Comment