P
Pam
, here is error message before last one
thanks
2006-03-23 10:00:00.31 server Microsoft SQL Server 2000 - 8.00.818
(Intel X86)
May 31 2003 16:08:15
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 2)
2006-03-23 10:00:00.34 server Copyright (C) 1988-2002 Microsoft
Corporation.
2006-03-23 10:00:00.34 server All rights reserved.
2006-03-23 10:00:00.34 server Server Process ID is 236.
2006-03-23 10:00:00.34 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL
Server\MSSQL$MICROSOFTBCM\LOG\ERRORLOG'.
2006-03-23 10:00:00.36 server SQL Server is starting at priority
class 'normal'(2 CPUs detected).
2006-03-23 10:00:00.45 server SQL Server configured for thread mode
processing.
2006-03-23 10:00:00.48 server Using dynamic lock allocation. [500]
Lock Blocks, [1000] Lock Owner Blocks.
2006-03-23 10:00:00.63 spid4 Starting up database 'master'.
2006-03-23 10:00:01.08 server Using 'SSNETLIB.DLL' version
'8.0.818'.
2006-03-23 10:00:01.08 spid5 Starting up database 'model'.
2006-03-23 10:00:01.11 server SQL server listening on Shared Memory.
2006-03-23 10:00:01.11 server SQL Server is ready for client
connections
2006-03-23 10:00:01.14 spid4 Server name is
'REALTY-DHJ8PGNG\MICROSOFTBCM'.
2006-03-23 10:00:01.14 spid4 Skipping startup of clean database id
4
2006-03-23 10:00:01.27 spid5 Clearing tempdb database.
2006-03-23 10:00:02.01 spid5 Starting up database 'tempdb'.
2006-03-23 10:00:02.16 spid4 Recovery complete.
2006-03-23 10:00:02.16 spid4 SQL global counter collection task is
created.
2006-03-23 10:00:13.75 spid51 Starting up database 'msdb'.
2006-03-23 10:00:24.61 spid51 Using 'xpsqlbot.dll' version
'2000.80.760' to execute extended stored procedure 'xp_qv'.
2006-03-23 10:00:36.28 spid52 Error: 15457, Severity: 0, State: 1
2006-03-23 10:00:36.28 spid52 Configuration option 'allow updates'
changed from 0 to 1. Run the RECONFIGURE statement to install..
2006-03-23 10:00:36.72 spid52 DBCC TRACEON 1717, server process ID
(SPID) 52.
2006-03-23 10:03:23.89 spid52 Error: 15457, Severity: 0, State: 1
2006-03-23 10:03:23.89 spid52 Configuration option 'allow updates'
changed from 1 to 0. Run the RECONFIGURE statement to install..
2006-03-23 10:03:24.36 spid52 DBCC TRACEOFF 1717, server process ID
(SPID) 52.
2006-03-23 10:03:29.94 spid52 Error: 15457, Severity: 0, State: 1
2006-03-23 10:03:29.94 spid52 Configuration option 'allow updates'
changed from 0 to 1. Run the RECONFIGURE statement to install..
2006-03-23 10:03:48.83 spid52 Error: 15457, Severity: 0, State: 1
2006-03-23 10:03:48.83 spid52 Configuration option 'allow updates'
changed from 1 to 1. Run the RECONFIGURE statement to install..
2006-03-23 10:04:47.59 spid52 Error: 15457, Severity: 0, State: 1
2006-03-23 10:04:47.59 spid52 Configuration option 'allow updates'
changed from 1 to 1. Run the RECONFIGURE statement to install..
2006-03-23 10:05:47.94 spid52 Error: 15457, Severity: 0, State: 1
2006-03-23 10:05:47.94 spid52 Configuration option 'allow updates'
changed from 1 to 0. Run the RECONFIGURE statement to install..
2006-03-23 10:05:49.28 spid52 Error: 15457, Severity: 0, State: 1
2006-03-23 10:05:49.28 spid52 Configuration option 'allow updates'
changed from 0 to 1. Run the RECONFIGURE statement to install..
2006-03-23 10:05:49.41 spid52 DBCC TRACEON 1717, server process ID
(SPID) 52.
2006-03-23 10:06:02.95 spid52 DBCC TRACEOFF 1717, server process ID
(SPID) 52.
2006-03-23 10:06:03.16 spid52 Error: 15457, Severity: 0, State: 1
2006-03-23 10:06:03.16 spid52 Configuration option 'allow updates'
changed from 1 to 0. Run the RECONFIGURE statement to install..
2006-03-23 09:58:52.22 server Microsoft SQL Server 2000 - 8.00.760
(Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 2)
2006-03-23 09:58:52.22 server Copyright (C) 1988-2002 Microsoft
Corporation.
2006-03-23 09:58:52.22 server All rights reserved.
2006-03-23 09:58:52.22 server Server Process ID is 7388.
2006-03-23 09:58:52.22 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL
Server\MSSQL$MICROSOFTBCM\LOG\ERRORLOG'.
2006-03-23 09:58:52.23 server SQL Server is starting at priority
class 'normal'(2 CPUs detected).
2006-03-23 09:58:52.25 server SQL Server configured for thread mode
processing.
2006-03-23 09:58:52.25 server Using dynamic lock allocation. [500]
Lock Blocks, [1000] Lock Owner Blocks.
2006-03-23 09:58:52.27 spid4 Starting up database 'master'.
2006-03-23 09:58:52.45 server Using 'SSNETLIB.DLL' version
'8.0.766'.
2006-03-23 09:58:52.45 spid5 Starting up database 'model'.
2006-03-23 09:58:52.47 server SQL server listening on Shared Memory.
2006-03-23 09:58:52.47 server SQL Server is ready for client
connections
2006-03-23 09:58:52.48 spid4 Server name is
'REALTY-DHJ8PGNG\MICROSOFTBCM'.
2006-03-23 09:58:52.48 spid4 Skipping startup of clean database id
4
2006-03-23 09:58:52.64 spid5 Clearing tempdb database.
2006-03-23 09:58:53.31 spid5 Starting up database 'tempdb'.
2006-03-23 09:58:53.63 spid4 Recovery complete.
2006-03-23 09:58:53.63 spid4 SQL global counter collection task is
created.
2006-03-23 09:59:34.56 spid4 SQL Server is terminating due to
'stop' request from Service Control Manager.
thanks
2006-03-23 10:00:00.31 server Microsoft SQL Server 2000 - 8.00.818
(Intel X86)
May 31 2003 16:08:15
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 2)
2006-03-23 10:00:00.34 server Copyright (C) 1988-2002 Microsoft
Corporation.
2006-03-23 10:00:00.34 server All rights reserved.
2006-03-23 10:00:00.34 server Server Process ID is 236.
2006-03-23 10:00:00.34 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL
Server\MSSQL$MICROSOFTBCM\LOG\ERRORLOG'.
2006-03-23 10:00:00.36 server SQL Server is starting at priority
class 'normal'(2 CPUs detected).
2006-03-23 10:00:00.45 server SQL Server configured for thread mode
processing.
2006-03-23 10:00:00.48 server Using dynamic lock allocation. [500]
Lock Blocks, [1000] Lock Owner Blocks.
2006-03-23 10:00:00.63 spid4 Starting up database 'master'.
2006-03-23 10:00:01.08 server Using 'SSNETLIB.DLL' version
'8.0.818'.
2006-03-23 10:00:01.08 spid5 Starting up database 'model'.
2006-03-23 10:00:01.11 server SQL server listening on Shared Memory.
2006-03-23 10:00:01.11 server SQL Server is ready for client
connections
2006-03-23 10:00:01.14 spid4 Server name is
'REALTY-DHJ8PGNG\MICROSOFTBCM'.
2006-03-23 10:00:01.14 spid4 Skipping startup of clean database id
4
2006-03-23 10:00:01.27 spid5 Clearing tempdb database.
2006-03-23 10:00:02.01 spid5 Starting up database 'tempdb'.
2006-03-23 10:00:02.16 spid4 Recovery complete.
2006-03-23 10:00:02.16 spid4 SQL global counter collection task is
created.
2006-03-23 10:00:13.75 spid51 Starting up database 'msdb'.
2006-03-23 10:00:24.61 spid51 Using 'xpsqlbot.dll' version
'2000.80.760' to execute extended stored procedure 'xp_qv'.
2006-03-23 10:00:36.28 spid52 Error: 15457, Severity: 0, State: 1
2006-03-23 10:00:36.28 spid52 Configuration option 'allow updates'
changed from 0 to 1. Run the RECONFIGURE statement to install..
2006-03-23 10:00:36.72 spid52 DBCC TRACEON 1717, server process ID
(SPID) 52.
2006-03-23 10:03:23.89 spid52 Error: 15457, Severity: 0, State: 1
2006-03-23 10:03:23.89 spid52 Configuration option 'allow updates'
changed from 1 to 0. Run the RECONFIGURE statement to install..
2006-03-23 10:03:24.36 spid52 DBCC TRACEOFF 1717, server process ID
(SPID) 52.
2006-03-23 10:03:29.94 spid52 Error: 15457, Severity: 0, State: 1
2006-03-23 10:03:29.94 spid52 Configuration option 'allow updates'
changed from 0 to 1. Run the RECONFIGURE statement to install..
2006-03-23 10:03:48.83 spid52 Error: 15457, Severity: 0, State: 1
2006-03-23 10:03:48.83 spid52 Configuration option 'allow updates'
changed from 1 to 1. Run the RECONFIGURE statement to install..
2006-03-23 10:04:47.59 spid52 Error: 15457, Severity: 0, State: 1
2006-03-23 10:04:47.59 spid52 Configuration option 'allow updates'
changed from 1 to 1. Run the RECONFIGURE statement to install..
2006-03-23 10:05:47.94 spid52 Error: 15457, Severity: 0, State: 1
2006-03-23 10:05:47.94 spid52 Configuration option 'allow updates'
changed from 1 to 0. Run the RECONFIGURE statement to install..
2006-03-23 10:05:49.28 spid52 Error: 15457, Severity: 0, State: 1
2006-03-23 10:05:49.28 spid52 Configuration option 'allow updates'
changed from 0 to 1. Run the RECONFIGURE statement to install..
2006-03-23 10:05:49.41 spid52 DBCC TRACEON 1717, server process ID
(SPID) 52.
2006-03-23 10:06:02.95 spid52 DBCC TRACEOFF 1717, server process ID
(SPID) 52.
2006-03-23 10:06:03.16 spid52 Error: 15457, Severity: 0, State: 1
2006-03-23 10:06:03.16 spid52 Configuration option 'allow updates'
changed from 1 to 0. Run the RECONFIGURE statement to install..
2006-03-23 09:58:52.22 server Microsoft SQL Server 2000 - 8.00.760
(Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 2)
2006-03-23 09:58:52.22 server Copyright (C) 1988-2002 Microsoft
Corporation.
2006-03-23 09:58:52.22 server All rights reserved.
2006-03-23 09:58:52.22 server Server Process ID is 7388.
2006-03-23 09:58:52.22 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL
Server\MSSQL$MICROSOFTBCM\LOG\ERRORLOG'.
2006-03-23 09:58:52.23 server SQL Server is starting at priority
class 'normal'(2 CPUs detected).
2006-03-23 09:58:52.25 server SQL Server configured for thread mode
processing.
2006-03-23 09:58:52.25 server Using dynamic lock allocation. [500]
Lock Blocks, [1000] Lock Owner Blocks.
2006-03-23 09:58:52.27 spid4 Starting up database 'master'.
2006-03-23 09:58:52.45 server Using 'SSNETLIB.DLL' version
'8.0.766'.
2006-03-23 09:58:52.45 spid5 Starting up database 'model'.
2006-03-23 09:58:52.47 server SQL server listening on Shared Memory.
2006-03-23 09:58:52.47 server SQL Server is ready for client
connections
2006-03-23 09:58:52.48 spid4 Server name is
'REALTY-DHJ8PGNG\MICROSOFTBCM'.
2006-03-23 09:58:52.48 spid4 Skipping startup of clean database id
4
2006-03-23 09:58:52.64 spid5 Clearing tempdb database.
2006-03-23 09:58:53.31 spid5 Starting up database 'tempdb'.
2006-03-23 09:58:53.63 spid4 Recovery complete.
2006-03-23 09:58:53.63 spid4 SQL global counter collection task is
created.
2006-03-23 09:59:34.56 spid4 SQL Server is terminating due to
'stop' request from Service Control Manager.