is this a connection problem or am I going bonkers?

I have SQL installed locally, and it has been working fine for some time.
However, today when I went to Enterprise Manager I could see the tree view
but as soon as I selected "Databases" everything froze, Task Manager
reported that the application was not responding. I left it for 10 minutes
and the
screen stayed stuck with the hourglass.
I tried re-starting the SQL service and rebooting the box, but the same
problem occured.
When I try and use Query Analyser, I cannot select a database from the
drop down list, but, I can use the "Use" command to choose a database and I
can
run a query. It is unblievably slow though.
Just tried to create a new ODBC connection and the test failed because of a
timeout.
Does anyone have any clues?
I've posted the log below
thanks
J
2004-11-30 14:59:48.59 server Microsoft SQL Server 2000 - 8.00.194
(Intel X86)
Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation
Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
2004-11-30 14:59:48.60 server Copyright (C) 1988-2000 Microsoft
Corporation.
2004-11-30 14:59:48.60 server All rights reserved.
2004-11-30 14:59:48.60 server Server Process ID is 1636.
2004-11-30 14:59:48.60 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
2004-11-30 14:59:48.66 server SQL Server is starting at priority class
'normal'(1 CPU detected).
2004-11-30 14:59:49.44 server SQL Server configured for thread mode
processing.
2004-11-30 14:59:49.49 server Using dynamic lock allocation. [2500] L
ock
Blocks, [5000] Lock Owner Blocks.
2004-11-30 14:59:49.55 server Attempting to initialize Distributed
Transaction Coordinator.
2004-11-30 14:59:49.96 server Failed to obtain
TransactionDispenserInterface: Result Code = 0x8004d01b
2004-11-30 14:59:50.01 spid3 Starting up database 'master'.
2004-11-30 14:59:52.47 spid3 0 transactions rolled back in database
'master' (1).
2004-11-30 14:59:52.48 spid3 Recovery is checkpointing database 'master'
(1)
2004-11-30 14:59:52.62 server Using 'SSNETLIB.DLL' version '8.0.194'.
2004-11-30 14:59:52.63 spid5 Starting up database 'model'.
2004-11-30 14:59:52.76 spid3 Server name is 'OBIWAN'.
2004-11-30 14:59:52.76 spid3 Skipping startup of clean database id 7
2004-11-30 14:59:52.76 spid3 Skipping startup of clean database id 11
2004-11-30 14:59:52.76 spid3 Skipping startup of clean database id 12
2004-11-30 14:59:52.78 server SQL server listening on Shared Memory,
Named Pipes.
2004-11-30 14:59:52.78 server SQL Server is ready for client connections
2004-11-30 14:59:52.78 spid8 Starting up database 'msdb'.
2004-11-30 14:59:52.85 spid9 Starting up database 'pubs'.
2004-11-30 14:59:52.86 spid10 Starting up database 'Northwind'.
2004-11-30 14:59:52.99 spid11 Starting up database 'isoglobal'.
2004-11-30 14:59:53.80 spid5 Clearing tempdb database.
2004-11-30 14:59:54.18 spid9 Starting up database 'vmserver'.
2004-11-30 14:59:54.33 spid10 Starting up database 'vmserver_delivery'.
2004-11-30 14:59:56.76 spid5 Starting up database 'tempdb'.
2004-11-30 14:59:57.02 spid3 Recovery complete.
2004-11-30 15:35:06.94 spid52 Starting up database '3663'.
2004-11-30 15:35:07.47 spid52 Starting up database 'demo'.
2004-11-30 15:35:07.81 spid52 Starting up database 'fsspda'.
2004-11-30 15:35:10.27 spid51 Starting up database '3663'.
2004-11-30 15:35:26.30 spid51 Starting up database 'demo'.
2004-11-30 15:35:45.90 spid51 Starting up database 'fsspda'.
2004-11-30 15:36:09.88 spid51 Starting up database '3663'.
2004-11-30 15:36:27.73 spid51 Starting up database 'demo'.
2004-11-30 15:36:45.81 spid51 Starting up database 'fsspda'.
2004-11-30 15:37:24.86 spid51 Starting up database 'demo'.
2004-11-30 15:37:43.23 spid51 Starting up database 'demo'.
2004-11-30 15:38:03.14 spid51 Starting up database 'demo'.
2004-11-30 15:50:39.57 spid53 Using 'xpstar.dll' version '2000.80.194' to
execute extended stored procedure 'sp_MSgetversion'.
2004-11-30 15:50:56.32 spid53 Starting up database '3663'.
2004-11-30 15:50:56.79 spid53 Starting up database 'fsspda'.
2004-11-30 15:50:57.26 spid53 Starting up database '3663'.
2004-11-30 15:51:13.34 spid53 Starting up database 'fsspda'.
2004-11-30 15:51:27.99 spid53 Starting up database '3663'.
2004-11-30 15:51:43.49 spid53 Starting up database 'fsspda'.
2004-11-30 15:51:59.48 spid53 Starting up database '3663'.
2004-11-30 15:52:22.68 spid53 Starting up database 'fsspda'.
2004-11-30 15:52:40.95 spid53 Starting up database '3663'.
2004-11-30 15:53:01.00 spid53 Starting up database 'fsspda'.
2004-11-30 15:53:16.65 spid53 Starting up database '3663'.
2004-11-30 15:53:33.17 spid53 Starting up database 'fsspda'.
2004-11-30 15:53:48.53 spid53 Starting up database '3663'.
2004-11-30 15:53:49.39 spid53 Starting up database 'fsspda'.
2004-11-30 15:53:50.02 spid53 Starting up database '3663'.
2004-11-30 15:53:50.78 spid53 Starting up database 'fsspda'.
2004-11-30 15:53:51.56 spid53 Starting up database '3663'.
2004-11-30 15:53:52.22 spid53 Starting up database 'fsspda'.
2004-11-30 15:53:52.53 spid53 Starting up database '3663'.
2004-11-30 15:53:52.87 spid53 Starting up database 'fsspda'.
2004-11-30 15:53:53.16 spid53 Starting up database '3663'.
2004-11-30 15:53:53.52 spid53 Starting up database 'fsspda'.
2004-11-30 15:53:53.87 spid53 Starting up database '3663'.
2004-11-30 15:53:54.19 spid53 Starting up database 'fsspda'.
2004-11-30 15:53:54.49 spid53 Starting up database '3663'.
2004-11-30 15:53:54.97 spid53 Starting up database 'fsspda'.
2004-11-30 15:53:55.33 spid53 Starting up database '3663'.
2004-11-30 15:53:55.68 spid53 Starting up database 'fsspda'.
2004-11-30 15:53:56.01 spid53 Starting up database '3663'.
2004-11-30 15:53:56.90 spid53 Starting up database 'fsspda'.
2004-11-30 15:53:57.45 spid53 Starting up database '3663'.
2004-11-30 15:53:57.81 spid53 Starting up database 'fsspda'.
2004-11-30 15:54:04.61 spid51 Starting up database 'fsspda'.
2004-11-30 15:54:05.02 spid51 Starting up database 'fsspda'.
2004-11-30 15:54:05.45 spid51 Starting up database 'fsspda'.
2004-11-30 15:54:09.62 spid51 Starting up database '3663'.
2004-11-30 15:54:10.05 spid51 Starting up database 'demo'.
2004-11-30 15:54:17.14 spid51 Starting up database 'demo'.
2004-11-30 15:54:17.46 spid51 Starting up database 'demo'.
2004-11-30 15:54:17.82 spid51 Starting up database 'demo'.
2004-11-30 15:54:33.58 spid53 Starting up database 'Route'.
2004-11-30 15:54:34.32 spid53 Starting up database '3663'.
2004-11-30 15:54:34.76 spid53 Starting up database 'fsspda'.
2004-11-30 15:54:35.07 spid53 Starting up database '3663'.
2004-11-30 15:54:35.38 spid53 Starting up database 'fsspda'.
2004-11-30 15:58:19.63 spid51 Starting up database '3663'.
2004-11-30 15:58:37.12 spid51 Starting up database 'fsspda'.
2004-11-30 15:58:52.46 spid51 Starting up database '3663'.
2004-11-30 15:59:09.98 spid51 Starting up database 'demo'.
2004-11-30 15:59:41.81 spid51 Starting up database 'fsspda'.
2004-11-30 15:59:59.34 spid51 Starting up database '3663'.
2004-11-30 16:00:15.76 spid51 Starting up database 'demo'.
2004-11-30 16:00:50.61 spid51 Starting up database 'fsspda'.
2004-11-30 16:00:51.36 spid51 Starting up database '3663'.
2004-11-30 16:01:10.96 spid51 Starting up database 'demo'.
2004-11-30 16:01:30.14 spid51 Starting up database 'fsspda'.
2004-11-30 16:01:45.79 spid51 Starting up database '3663'.
2004-11-30 16:02:01.59 spid51 Starting up database 'demo'.
2004-11-30 16:02:05.37 spid51 Starting up database 'fsspda'.
2004-11-30 16:02:21.41 spid51 Starting up database '3663'.
2004-11-30 16:02:38.84 spid51 Starting up database 'demo'.
2004-11-30 16:02:58.05 spid51 Starting up database 'fsspda'.
2004-11-30 16:03:13.71 spid51 Starting up database '3663'.
2004-11-30 16:03:34.68 spid51 Starting up database 'demo'.
2004-11-30 16:03:56.00 spid51 Starting up database 'fsspda'.
2004-11-30 16:04:12.85 spid51 Starting up database '3663'.
2004-11-30 16:04:29.93 spid51 Starting up database 'demo'.
2004-11-30 16:04:50.03 spid51 Starting up database 'fsspda'.
2004-11-30 16:05:06.56 spid51 Starting up database '3663'.
2004-11-30 16:05:24.32 spid51 Starting up database 'demo'.
2004-11-30 16:05:51.91 spid53 Starting up database '3663'.
2004-11-30 16:06:10.79 spid51 Starting up database 'fsspda'.
2004-11-30 16:06:26.38 spid53 Starting up database 'demo'.
2004-11-30 16:06:46.93 spid51 Starting up database '3663'.
2004-11-30 16:07:05.64 spid53 Starting up database 'fsspda'.
2004-11-30 16:07:21.08 spid51 Starting up database 'demo'.
2004-11-30 16:07:22.29 spid51 Starting up database 'fsspda'.
2004-11-30 16:07:40.60 spid51 Starting up database '3663'.
2004-11-30 16:07:59.85 spid51 Starting up database 'demo'.
2004-11-30 16:08:25.22 spid51 Starting up database 'fsspda'.
2004-11-30 16:08:44.40 spid51 Starting up database '3663'.
2004-11-30 16:09:02.97 spid51 Starting up database 'demo'.
2004-11-30 16:09:34.28 spid51 Starting up database 'fsspda'.
2004-11-30 16:12:52.66 spid51 Starting up database 'fsspda'.
2004-11-30 16:12:53.04 spid51 Starting up database 'demo'.
2004-11-30 16:12:53.45 spid51 Starting up database '3663'.
2004-11-30 16:12:56.66 spid52 Starting up database 'fsspda'.Neither...it's from having auto close turned on. See my
posts to your same question in the server newsgroup.
-Sue
On Tue, 30 Nov 2004 09:45:07 -0800, "McFly"
<McFly@.discussions.microsoft.com> wrote:

> I have SQL installed locally, and it has been working fine for some time.
> However, today when I went to Enterprise Manager I could see the tree view
> but as soon as I selected "Databases" everything froze, Task Manager
> reported that the application was not responding. I left it for 10 minute
s
>and the
> screen stayed stuck with the hourglass.
> I tried re-starting the SQL service and rebooting the box, but the same
> problem occured.
> When I try and use Query Analyser, I cannot select a database from the
> drop down list, but, I can use the "Use" command to choose a database and
I
>can
> run a query. It is unblievably slow though.
>Just tried to create a new ODBC connection and the test failed because of a
>timeout.
>
> Does anyone have any clues?
>I've posted the log below
>thanks
>J
>2004-11-30 14:59:48.59 server Microsoft SQL Server 2000 - 8.00.194
>(Intel X86)
> Aug 6 2000 00:57:48
> Copyright (c) 1988-2000 Microsoft Corporation
> Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
>2004-11-30 14:59:48.60 server Copyright (C) 1988-2000 Microsoft
>Corporation.
>2004-11-30 14:59:48.60 server All rights reserved.
>2004-11-30 14:59:48.60 server Server Process ID is 1636.
>2004-11-30 14:59:48.60 server Logging SQL Server messages in file
>'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
>2004-11-30 14:59:48.66 server SQL Server is starting at priority class
>'normal'(1 CPU detected).
>2004-11-30 14:59:49.44 server SQL Server configured for thread mode
>processing.
>2004-11-30 14:59:49.49 server Using dynamic lock allocation. [2500]
Lock
>Blocks, [5000] Lock Owner Blocks.
>2004-11-30 14:59:49.55 server Attempting to initialize Distributed
>Transaction Coordinator.
>2004-11-30 14:59:49.96 server Failed to obtain
>TransactionDispenserInterface: Result Code = 0x8004d01b
>2004-11-30 14:59:50.01 spid3 Starting up database 'master'.
>2004-11-30 14:59:52.47 spid3 0 transactions rolled back in database
>'master' (1).
>2004-11-30 14:59:52.48 spid3 Recovery is checkpointing database 'master
'
>(1)
>2004-11-30 14:59:52.62 server Using 'SSNETLIB.DLL' version '8.0.194'.
>2004-11-30 14:59:52.63 spid5 Starting up database 'model'.
>2004-11-30 14:59:52.76 spid3 Server name is 'OBIWAN'.
>2004-11-30 14:59:52.76 spid3 Skipping startup of clean database id 7
>2004-11-30 14:59:52.76 spid3 Skipping startup of clean database id 11
>2004-11-30 14:59:52.76 spid3 Skipping startup of clean database id 12
>2004-11-30 14:59:52.78 server SQL server listening on Shared Memory,
>Named Pipes.
>2004-11-30 14:59:52.78 server SQL Server is ready for client connections
>2004-11-30 14:59:52.78 spid8 Starting up database 'msdb'.
>2004-11-30 14:59:52.85 spid9 Starting up database 'pubs'.
>2004-11-30 14:59:52.86 spid10 Starting up database 'Northwind'.
>2004-11-30 14:59:52.99 spid11 Starting up database 'isoglobal'.
>2004-11-30 14:59:53.80 spid5 Clearing tempdb database.
>2004-11-30 14:59:54.18 spid9 Starting up database 'vmserver'.
>2004-11-30 14:59:54.33 spid10 Starting up database 'vmserver_delivery'.
>2004-11-30 14:59:56.76 spid5 Starting up database 'tempdb'.
>2004-11-30 14:59:57.02 spid3 Recovery complete.
>2004-11-30 15:35:06.94 spid52 Starting up database '3663'.
>2004-11-30 15:35:07.47 spid52 Starting up database 'demo'.
>2004-11-30 15:35:07.81 spid52 Starting up database 'fsspda'.
>2004-11-30 15:35:10.27 spid51 Starting up database '3663'.
>2004-11-30 15:35:26.30 spid51 Starting up database 'demo'.
>2004-11-30 15:35:45.90 spid51 Starting up database 'fsspda'.
>2004-11-30 15:36:09.88 spid51 Starting up database '3663'.
>2004-11-30 15:36:27.73 spid51 Starting up database 'demo'.
>2004-11-30 15:36:45.81 spid51 Starting up database 'fsspda'.
>2004-11-30 15:37:24.86 spid51 Starting up database 'demo'.
>2004-11-30 15:37:43.23 spid51 Starting up database 'demo'.
>2004-11-30 15:38:03.14 spid51 Starting up database 'demo'.
>2004-11-30 15:50:39.57 spid53 Using 'xpstar.dll' version '2000.80.194' t
o
>execute extended stored procedure 'sp_MSgetversion'.
>2004-11-30 15:50:56.32 spid53 Starting up database '3663'.
>2004-11-30 15:50:56.79 spid53 Starting up database 'fsspda'.
>2004-11-30 15:50:57.26 spid53 Starting up database '3663'.
>2004-11-30 15:51:13.34 spid53 Starting up database 'fsspda'.
>2004-11-30 15:51:27.99 spid53 Starting up database '3663'.
>2004-11-30 15:51:43.49 spid53 Starting up database 'fsspda'.
>2004-11-30 15:51:59.48 spid53 Starting up database '3663'.
>2004-11-30 15:52:22.68 spid53 Starting up database 'fsspda'.
>2004-11-30 15:52:40.95 spid53 Starting up database '3663'.
>2004-11-30 15:53:01.00 spid53 Starting up database 'fsspda'.
>2004-11-30 15:53:16.65 spid53 Starting up database '3663'.
>2004-11-30 15:53:33.17 spid53 Starting up database 'fsspda'.
>2004-11-30 15:53:48.53 spid53 Starting up database '3663'.
>2004-11-30 15:53:49.39 spid53 Starting up database 'fsspda'.
>2004-11-30 15:53:50.02 spid53 Starting up database '3663'.
>2004-11-30 15:53:50.78 spid53 Starting up database 'fsspda'.
>2004-11-30 15:53:51.56 spid53 Starting up database '3663'.
>2004-11-30 15:53:52.22 spid53 Starting up database 'fsspda'.
>2004-11-30 15:53:52.53 spid53 Starting up database '3663'.
>2004-11-30 15:53:52.87 spid53 Starting up database 'fsspda'.
>2004-11-30 15:53:53.16 spid53 Starting up database '3663'.
>2004-11-30 15:53:53.52 spid53 Starting up database 'fsspda'.
>2004-11-30 15:53:53.87 spid53 Starting up database '3663'.
>2004-11-30 15:53:54.19 spid53 Starting up database 'fsspda'.
>2004-11-30 15:53:54.49 spid53 Starting up database '3663'.
>2004-11-30 15:53:54.97 spid53 Starting up database 'fsspda'.
>2004-11-30 15:53:55.33 spid53 Starting up database '3663'.
>2004-11-30 15:53:55.68 spid53 Starting up database 'fsspda'.
>2004-11-30 15:53:56.01 spid53 Starting up database '3663'.
>2004-11-30 15:53:56.90 spid53 Starting up database 'fsspda'.
>2004-11-30 15:53:57.45 spid53 Starting up database '3663'.
>2004-11-30 15:53:57.81 spid53 Starting up database 'fsspda'.
>2004-11-30 15:54:04.61 spid51 Starting up database 'fsspda'.
>2004-11-30 15:54:05.02 spid51 Starting up database 'fsspda'.
>2004-11-30 15:54:05.45 spid51 Starting up database 'fsspda'.
>2004-11-30 15:54:09.62 spid51 Starting up database '3663'.
>2004-11-30 15:54:10.05 spid51 Starting up database 'demo'.
>2004-11-30 15:54:17.14 spid51 Starting up database 'demo'.
>2004-11-30 15:54:17.46 spid51 Starting up database 'demo'.
>2004-11-30 15:54:17.82 spid51 Starting up database 'demo'.
>2004-11-30 15:54:33.58 spid53 Starting up database 'Route'.
>2004-11-30 15:54:34.32 spid53 Starting up database '3663'.
>2004-11-30 15:54:34.76 spid53 Starting up database 'fsspda'.
>2004-11-30 15:54:35.07 spid53 Starting up database '3663'.
>2004-11-30 15:54:35.38 spid53 Starting up database 'fsspda'.
>2004-11-30 15:58:19.63 spid51 Starting up database '3663'.
>2004-11-30 15:58:37.12 spid51 Starting up database 'fsspda'.
>2004-11-30 15:58:52.46 spid51 Starting up database '3663'.
>2004-11-30 15:59:09.98 spid51 Starting up database 'demo'.
>2004-11-30 15:59:41.81 spid51 Starting up database 'fsspda'.
>2004-11-30 15:59:59.34 spid51 Starting up database '3663'.
>2004-11-30 16:00:15.76 spid51 Starting up database 'demo'.
>2004-11-30 16:00:50.61 spid51 Starting up database 'fsspda'.
>2004-11-30 16:00:51.36 spid51 Starting up database '3663'.
>2004-11-30 16:01:10.96 spid51 Starting up database 'demo'.
>2004-11-30 16:01:30.14 spid51 Starting up database 'fsspda'.
>2004-11-30 16:01:45.79 spid51 Starting up database '3663'.
>2004-11-30 16:02:01.59 spid51 Starting up database 'demo'.
>2004-11-30 16:02:05.37 spid51 Starting up database 'fsspda'.
>2004-11-30 16:02:21.41 spid51 Starting up database '3663'.
>2004-11-30 16:02:38.84 spid51 Starting up database 'demo'.
>2004-11-30 16:02:58.05 spid51 Starting up database 'fsspda'.
>2004-11-30 16:03:13.71 spid51 Starting up database '3663'.
>2004-11-30 16:03:34.68 spid51 Starting up database 'demo'.
>2004-11-30 16:03:56.00 spid51 Starting up database 'fsspda'.
>2004-11-30 16:04:12.85 spid51 Starting up database '3663'.
>2004-11-30 16:04:29.93 spid51 Starting up database 'demo'.
>2004-11-30 16:04:50.03 spid51 Starting up database 'fsspda'.
>2004-11-30 16:05:06.56 spid51 Starting up database '3663'.
>2004-11-30 16:05:24.32 spid51 Starting up database 'demo'.
>2004-11-30 16:05:51.91 spid53 Starting up database '3663'.
>2004-11-30 16:06:10.79 spid51 Starting up database 'fsspda'.
>2004-11-30 16:06:26.38 spid53 Starting up database 'demo'.
>2004-11-30 16:06:46.93 spid51 Starting up database '3663'.
>2004-11-30 16:07:05.64 spid53 Starting up database 'fsspda'.
>2004-11-30 16:07:21.08 spid51 Starting up database 'demo'.
>2004-11-30 16:07:22.29 spid51 Starting up database 'fsspda'.
>2004-11-30 16:07:40.60 spid51 Starting up database '3663'.
>2004-11-30 16:07:59.85 spid51 Starting up database 'demo'.
>2004-11-30 16:08:25.22 spid51 Starting up database 'fsspda'.
>2004-11-30 16:08:44.40 spid51 Starting up database '3663'.
>2004-11-30 16:09:02.97 spid51 Starting up database 'demo'.
>2004-11-30 16:09:34.28 spid51 Starting up database 'fsspda'.
>2004-11-30 16:12:52.66 spid51 Starting up database 'fsspda'.
>2004-11-30 16:12:53.04 spid51 Starting up database 'demo'.
>2004-11-30 16:12:53.45 spid51 Starting up database '3663'.
>2004-11-30 16:12:56.66 spid52 Starting up database 'fsspda'.
>