解决方案 »
- 求一条简单的SQL语句
- 请问如何在sqlserver中提高delete的性能?
- 数据库更新问题
- 一个看似简单的问题。我不会
- 求一触发器语句
- 500分求一个查询的问题已解决!请 txlicenhe(马可) realgz(realgz)等来领分!!
- 难道是sqlsever2000的bug,字符串比较中,只要出现‘-’,就会出现异常,不会是从左向右依次比较了,求权威的说法
- 数据库的连接延时问题?
- 请问如何在VFP中调用API函数 例如GetVolumnInformation()我想知道A:的序列号
- 数据库存储过程参数拼接
- sql的存储过程中,怎样实现批量更新表数据,要更新的id是动态的
- 请大家帮我改善一下这个语句的执行效率。
之前连接的时候是只用ip,没有采用楼上的IP\实例名,现在尝试看看。登陆方式是Sql Server身份验证。
http://www.sqlserverclub.com/essentialguides/how-to-configure-sql-server-2005-to-allow-remote-connections.aspx
Oct 14 2005 00:33:37
Copyright (c) 1988-2005 Microsoft Corporation
Standard Edition on Windows NT 5.1 (Build 2600: Service Pack 3)2013-01-30 14:41:29.590,Server,(c) 2005 Microsoft Corporation.
2013-01-30 14:41:29.590,Server,All rights reserved.
2013-01-30 14:41:29.590,Server,Server process ID is 452.
2013-01-30 14:41:29.590,Server,Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\LOG\ERRORLOG'.
2013-01-30 14:41:29.590,Server,This instance of SQL Server last reported using a process ID of 176 at 2013-1-30 11:35:02 (local) 2013-1-30 3:35:02 (UTC). This is an informational message only; no user action is required.
2013-01-30 14:41:29.590,Server,Registry startup parameters:
2013-01-30 14:41:29.620,Server, -d C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\DATA\master.mdf
2013-01-30 14:41:29.620,Server, -e C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\LOG\ERRORLOG
2013-01-30 14:41:29.620,Server, -l C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\DATA\mastlog.ldf
2013-01-30 14:41:29.870,服务器,SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2013-01-30 14:41:29.920,服务器,Detected 8 CPUs. This is an informational message; no user action is required.
2013-01-30 14:41:30.600,服务器,Set AWE Enabled to 1 in the configuration parameters to allow use of more memory.
2013-01-30 14:41:32.460,服务器,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.
2013-01-30 14:41:34.420,服务器,Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2013-01-30 14:41:34.740,服务器,The Microsoft Distributed Transaction Coordinator (MS DTC) service could not be contacted. If you would like distributed transaction functionality, please start this service.
2013-01-30 14:41:35.100,服务器,Database Mirroring Transport is disabled in the endpoint configuration.
2013-01-30 14:41:36.120,spid5s,Starting up database 'master'.
2013-01-30 14:41:37.710,spid5s,Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2013-01-30 14:41:40.200,spid5s,SQL Trace ID 1 was started by login "sa".
2013-01-30 14:41:40.780,spid5s,Starting up database 'mssqlsystemresource'.
2013-01-30 14:41:44.730,spid9s,Starting up database 'model'.
2013-01-30 14:41:44.780,spid5s,Server name is 'PC2011012317VDW\SQL2005'. This is an informational message only. No user action is required.
2013-01-30 14:41:46.670,服务器,A self-generated certificate was successfully loaded for encryption.
2013-01-30 14:41:46.790,服务器,Server is listening on [ 'any' <ipv4> 1433].
2013-01-30 14:41:46.820,服务器,Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\SQL2005 ].
2013-01-30 14:41:46.820,服务器,Server named pipe provider is ready to accept connection on [ \\.\pipe\MSSQL$SQL2005\sql\query ].
2013-01-30 14:41:46.840,服务器,Server is listening on [ 'any' <ipv4> 1509].
2013-01-30 14:41:46.840,服务器,Dedicated admin connection support was established for listening locally on port 1509.
2013-01-30 14:41:46.870,服务器,The SQL Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b. Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies.
2013-01-30 14:41:46.870,服务器,SQL Server is now ready for client connections. This is an informational message; no user action is required.
2013-01-30 14:41:47.870,spid9s,Clearing tempdb database.
2013-01-30 14:41:49.450,spid15s,Starting up database 'msdb'.
2013-01-30 14:41:49.460,spid13s,Starting up database 'InfoFees'.
2013-01-30 14:41:49.460,spid20s,Starting up database 'IllegalInformation'.
2013-01-30 14:41:49.460,spid19s,Starting up database 'xy_zrfr'.
2013-01-30 14:41:49.460,spid22s,Starting up database 'ttt'.
2013-01-30 14:41:49.460,spid14s,Starting up database 'ReportServer$SQL2005TempDB'.
2013-01-30 14:41:49.460,spid21s,Starting up database 'Thesis'.
2013-01-30 14:41:49.460,spid18s,Starting up database 'CompanyExport'.
2013-01-30 14:41:49.510,spid12s,Starting up database 'ReportServer$SQL2005'.
2013-01-30 14:41:49.510,spid16s,Starting up database 'ks513'.
2013-01-30 14:41:49.510,spid23s,Starting up database 'PAMSDB'.
2013-01-30 14:41:49.510,spid17s,Starting up database 'InfoFeesHistory'.
2013-01-30 14:42:02.170,spid9s,Starting up database 'tempdb'.
2013-01-30 14:42:06.790,spid12s,The Service Broker protocol transport is disabled or not configured.
2013-01-30 14:42:06.790,spid12s,The Database Mirroring protocol transport is disabled or not configured.
2013-01-30 14:42:08.590,spid12s,Service Broker manager has started.
2013-01-30 14:42:11.590,spid5s,Recovery is complete. This is an informational message only. No user action is required.
2013-01-30 14:50:15.270,spid54,Using 'xpstar90.dll' version '2005.90.1399' to execute extended stored procedure 'xp_readerrorlog'. This is an informational message only; no user action is required.