Sql 2005启动不了,报错如下时的解决办法!
解决办法:
开始->programs->MicroSoft SQL Server 2005->Configuration tools->SQL Server Configuration Manager
选择 SQL Server 2005 Network Configuartion-> Protocols for SQL ExpRESS 再 选择 TCP/IP 属性 ,选择IP Addresses
IP1 的 IP Address 请确认是 你服务器的 IP地址 , 如果服务器为本地的话。在网上邻居看一下IP 地址 填上。IP 2 为 127.0.0.1
---------------------------------------------------------------------------------------------------------------
报错如下:
2009-11-04 10:30:08.96 Server Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)
Oct 14 2005 00:33:37
Copyright (c) 1988-2005 Microsoft Corporation
Express Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
2009-11-04 10:30:08.96 Server (c) 2005 Microsoft Corporation.
2009-11-04 10:30:08.96 Server All rights reserved.
2009-11-04 10:30:08.96 Server Server process ID is 1344.
2009-11-04 10:30:08.96 Server Logging SQL Server messages in file 'c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2009-11-04 10:30:08.96 Server This instance of SQL Server last reported using a process ID of 1512 at 2009-11-4 10:28:23 (local) 2009-11-4 2:28:23 (UTC). This is an informational message only; no user action is required.
2009-11-04 10:30:08.96 Server Registry startup parameters:
2009-11-04 10:30:08.96 Server -d c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2009-11-04 10:30:08.96 Server -e c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2009-11-04 10:30:08.96 Server -l c:\Program Files\Microsoft SQL Server\MSSQL.1\MSS
相关文档:
ALTER DATABASE AdventureWorks ADD FILEGROUP [2003Q3]
创建文件组后,使用 ALTER DATABASE 将文件添加到该文件组中。
ALTER DATABASE AdventureWorks
ADD FILE
(NAME = N'2003Q3',
FILENAME = N'C:\AdventureWorks\2003Q3.ndf',
SIZE = 5MB,
MAXSIZE = 100MB,
FILEGROWTH = 5MB)
TO FILEGR ......
--查询当前连接的实例名
select @@servername--察看任何数据库属性
sp_helpdb master
--设置单用户模式,同时立即断开所有用户
alter database Northwind set single_user with rollback immediate--恢复正常
alter database Northwind set multi_user
--察看数据库属性
sp_helpdb--察看数据库恢复模式
selec ......
Comparison of SQL and MDX Syntax
The Multidimensional Expressions (MDX) syntax is similar to the syntax of Structured Query Language (SQL). In many ways, the functionality supplied by MDX is also similar to that of SQL; with effort, you can eve ......
安装前准备:
前言:
[学习SQL SERVER 2005系列]准备把学习2005的一些心得整理出来,和大家分享,共同学习一起提高。
安装准备:
1、SQL Server 2005 的各版本之间选择
大多数企业都在三个 SQL Server 版本之间选择:SQL Server 2005 Enterprise Edition、SQL Server 2005 Standard Edition 和 SQL Server 2 ......