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
>
Showing posts with label weekend. Show all posts
Showing posts with label weekend. Show all posts
Sunday, March 11, 2012
Friday, February 10, 2012
Cannot Restart SQL Server Agent
This morning when I checked to see if my weekend database jobs ran, I notice
d that the SQL Server Agent was stopped. I tried to restart it several time
s to no avail. I even stopped the SQL Server and restarted it, but the Agen
t will not start. The erro
r log has the following message in it: [241] Startup error: Unable to i
nitialize error reporting system (reason: Access is denied). The setup of t
he database has not changed (Windows 2000 Server/SQL Server 2000). The agen
t and MSSQLServer both login us
ing the same domain account which is in the administrator's group on the box
. The account role is System Administrator in SQL Server.Hi,
Try to change the start up account for SQL Agent to
"Local system account" and try starting the service.
Thanks
Hari
MCDBA
"James_Privett" <anonymous@.discussions.microsoft.com> wrote in message
news:F6066C48-9689-44DA-BA5B-6585E20B7C99@.microsoft.com...
> This morning when I checked to see if my weekend database jobs ran, I
noticed that the SQL Server Agent was stopped. I tried to restart it
several times to no avail. I even stopped the SQL Server and restarted it,
but the Agent will not start. The error log has the following message in
it: [241] Startup error: Unable to initialize error reporting system
(reason: Access is denied). The setup of the database has not changed
(Windows 2000 Server/SQL Server 2000). The agent and MSSQLServer both login
using the same domain account which is in the administrator's group on the
box. The account role is System Administrator in SQL Server.|||Thanks Hari! That worked...but I have no clue why it stopped working after
3 months with no problems...?
d that the SQL Server Agent was stopped. I tried to restart it several time
s to no avail. I even stopped the SQL Server and restarted it, but the Agen
t will not start. The erro
r log has the following message in it: [241] Startup error: Unable to i
nitialize error reporting system (reason: Access is denied). The setup of t
he database has not changed (Windows 2000 Server/SQL Server 2000). The agen
t and MSSQLServer both login us
ing the same domain account which is in the administrator's group on the box
. The account role is System Administrator in SQL Server.Hi,
Try to change the start up account for SQL Agent to
"Local system account" and try starting the service.
Thanks
Hari
MCDBA
"James_Privett" <anonymous@.discussions.microsoft.com> wrote in message
news:F6066C48-9689-44DA-BA5B-6585E20B7C99@.microsoft.com...
> This morning when I checked to see if my weekend database jobs ran, I
noticed that the SQL Server Agent was stopped. I tried to restart it
several times to no avail. I even stopped the SQL Server and restarted it,
but the Agent will not start. The error log has the following message in
it: [241] Startup error: Unable to initialize error reporting system
(reason: Access is denied). The setup of the database has not changed
(Windows 2000 Server/SQL Server 2000). The agent and MSSQLServer both login
using the same domain account which is in the administrator's group on the
box. The account role is System Administrator in SQL Server.|||Thanks Hari! That worked...but I have no clue why it stopped working after
3 months with no problems...?
Subscribe to:
Posts (Atom)