Originally Posted by
stealhtfire
how about give us some more information to work with such as error codes/logs ?
we cant do anything with this lulz
where 2 get logs lol
---------- Post added at 12:56 AM ---------- Previous post was at 12:54 AM ----------
nvm found it
Code:
2010-03-23 17:43:08.21 Server Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86)
Nov 24 2008 13:01:59
Copyright (c) 1988-2005 Microsoft Corporation
Express Edition on Windows NT 5.1 (Build 2600: Service Pack 3)
2010-03-23 17:43:08.21 Server (c) 2005 Microsoft Corporation.
2010-03-23 17:43:08.21 Server All rights reserved.
2010-03-23 17:43:08.22 Server Server process ID is 5676.
2010-03-23 17:43:08.22 Server Authentication mode is MIXED.
2010-03-23 17:43:08.22 Server Logging SQL Server messages in file 'c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2010-03-23 17:43:08.22 Server This instance of SQL Server last reported using a process ID of 1492 at 3/23/2010 5:43:02 PM (local) 3/23/2010 9:43:02 PM (UTC). This is an informational message only; no user action is required.
2010-03-23 17:43:08.22 Server Registry startup parameters:
2010-03-23 17:43:08.22 Server -d c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2010-03-23 17:43:08.22 Server -e c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2010-03-23 17:43:08.22 Server -l c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2010-03-23 17:43:08.22 Server Command Line Startup Parameters:
2010-03-23 17:43:08.22 Server -d c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Template Data\master.mdf
2010-03-23 17:43:08.22 Server -l c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Template Data\mastlog.ldf
2010-03-23 17:43:08.22 Server -m SqlSetup
2010-03-23 17:43:08.22 Server SqlSetup
2010-03-23 17:43:08.22 Server -Q
2010-03-23 17:43:08.22 Server -q SQL_Latin1_General_CP1_CI_AS
2010-03-23 17:43:08.23 Server -T 4022
2010-03-23 17:43:08.23 Server -T 3659
2010-03-23 17:43:08.23 Server -T 3610
2010-03-23 17:43:08.23 Server -T 4010
2010-03-23 17:43:08.29 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2010-03-23 17:43:08.29 Server Detected 1 CPUs. This is an informational message; no user action is required.
2010-03-23 17:43:08.75 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2010-03-23 17:43:08.82 Server Database Mirroring Transport is disabled in the endpoint configuration.
2010-03-23 17:43:08.82 spid5s Warning ******************
2010-03-23 17:43:08.83 spid5s SQL Server started in single-user mode. This an informational message only. No user action is required.
2010-03-23 17:43:08.83 spid5s Starting up database 'master'.
2010-03-23 17:43:09.12 spid5s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2010-03-23 17:43:09.17 spid5s SQL Trace ID 1 was started by login "sa".
2010-03-23 17:43:09.20 spid5s Starting up database 'mssqlsystemresource'.
2010-03-23 17:43:09.23 spid5s The resource database build version is 9.00.4035. This is an informational message only. No user action is required.
2010-03-23 17:43:09.61 spid7s Starting up database 'model'.
2010-03-23 17:43:09.61 spid5s Server name is 'MICHAEL-700CD7A\SQLEXPRESS'. This is an informational message only. No user action is required.
2010-03-23 17:43:10.62 Server A self-generated certificate was successfully loaded for encryption.
2010-03-23 17:43:10.62 Server Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\SQLEXPRESS ].
2010-03-23 17:43:10.63 Server Dedicated administrator connection support was not started because it is not available on this edition of SQL Server. This is an informational message only. No user action is required.
2010-03-23 17:43:10.64 Server SQL Server is now ready for client connections. This is an informational message; no user action is required.
2010-03-23 17:43:10.65 spid5s Starting up database 'msdb'.
2010-03-23 17:43:10.98 spid7s Clearing tempdb database.
2010-03-23 17:43:11.70 spid7s Starting up database 'tempdb'.
2010-03-23 17:43:11.82 spid5s Recovery is complete. This is an informational message only. No user action is required.
2010-03-23 17:43:12.22 spid51 Setting database option RECOVERY to SIMPLE for database model.
2010-03-23 17:43:12.42 spid51 Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.
2010-03-23 17:43:12.47 spid51 Configuration option 'default language' changed from 0 to 0. Run the RECONFIGURE statement to install.
2010-03-23 17:43:12.48 spid51 Configuration option 'default full-text language' changed from 1033 to 1033. Run the RECONFIGURE statement to install.
2010-03-23 17:43:12.49 spid51 Configuration option 'show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install.
2010-03-23 17:43:12.90 spid51 Setting database option NEW_BROKER to ON for database tempdb.
2010-03-23 17:43:12.96 spid51 Setting database option NEW_BROKER to ON for database msdb.
2010-03-23 17:43:13.62 spid51 Setting database option READ_ONLY to ON for database model.
2010-03-23 17:43:13.79 spid51 Starting up database 'model'.
2010-03-23 17:43:13.96 spid51 Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.
2010-03-23 17:43:13.97 spid51 Configuration option 'user instances enabled' changed from 1 to 0. Run the RECONFIGURE statement to install.
2010-03-23 17:43:13.98 spid51 Configuration option 'show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install.
2010-03-23 17:43:17.89 spid51 DBCC TRACEON 4606, server process ID (SPID) 51. This is an informational message only; no user action is required.
2010-03-23 17:43:18.61 spid51 DBCC TRACEOFF 4606, server process ID (SPID) 51. This is an informational message only; no user action is required.
2010-03-23 17:43:25.67 spid51 Starting up database 'temp_MS_AgentSigningCertificate_database'.
2010-03-23 17:43:26.09 spid51 Using 'xpstar90.dll' version '2005.90.4035' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required.
2010-03-23 17:43:26.11 spid51 Using 'xplog70.dll' version '2005.90.4035' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is required.
2010-03-23 17:43:26.87 spid5s SQL Server is terminating in response to a 'stop' request from Service Control Manager. This is an informational message only. No user action is required.
2010-03-23 17:43:26.87 spid5s SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.
Reply With Quote