SQL Server 2005无法启动~！！！！
2010-05-05 13:35:52.06 Server Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)
Oct 14 2005 00:33:37
Copyright (c) 1988-2005 Microsoft Corporation
Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 3)
2010-05-05 13:35:52.06 Server (c) 2005 Microsoft Corporation.
2010-05-05 13:35:52.06 Server All rights reserved.
2010-05-05 13:35:52.06 Server Server process ID is 2848.
2010-05-05 13:35:52.06 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2010-05-05 13:35:52.06 Server This instance of SQL Server last reported using a process ID of 3348 at 2010-5-5 13:35:11 (local) 2010-5-5 5:35:11 (UTC). This is an informational message only; no user action is required.
2010-05-05 13:35:52.06 Server Registry startup parameters:
2010-05-05 13:35:52.06 Server -d C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2010-05-05 13:35:52.06 Server -e C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2010-05-05 13:35:52.06 Server -l C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2010-05-05 13:35:52.10 服务器 SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2010-05-05 13:35:52.10 服务器 Detected 2 CPUs. This is an informational message; no user action is required.
2010-05-05 13:35:52.51 服务器 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-05-05 13:35:52.54 服务器 Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2010-05-05 13:35:52.56 服务器 The Microsoft Distributed Transaction Coordinator (MS DTC) service could not be contacted. If you would like
相关文档：
Microsoft SQL Server 2008 对 T-SQL 语言进行了进一步增强。为了让开发人员尽快了解这些变化，我们针对 2007 年 6 月 CTP 版本的 SQL Server 2008 中的 T-SQL 语言的新增功能进行了分析和尝试。本文描述自 SQL Server 2008 CTP1 以来这些语言增强和变化。
本文包含如下内容：
· T-SQL 行构造器
&mid ......
追加：row_number, rank, dese_rank, ntile
1. row_number: 为查询出来的每一行记录生成一个序号。
SELECT row_number() OVER(ORDER BY field) AS row_n
from tablename;
分页查询：
with t_towtable
as (select row_number over(order by field1) as row_number from tb)
select * from t_rowtable where row_numbe ......
sql server出现选定的用户拥有对象而无法删除的处理
2006-4-5 19:50:00
方法一
首先你需要做的第一件事
企业管理器-〉选择服务器-〉属***-〉服务器设置-〉挑上允许对系统目录。。。-〉确定
第二步
找到你的数据库找到sysusers表那你以前的用户删除
第三步回去吧属***值改回来
第四部重建用户即可
方法二
� ......
alert index mem_ct monitoring usage;
desc v$object_usage;
set linesize 190
select * from v$object_usage;
SQL>SET AUTOTRACE ON;
*autotrace功能只能在SQL*PLUS里使用
其他一些使用方法：
2.2.1、在SQLPLUS中得到语句总的执行时间
SQL> set timing on;
2.2.2、只显示执行计划--(会同� ......
常用： Select CONVERT(varchar(100), GETDATE(), 8): 10:57:46
Select CONVERT(varchar(100), GETDATE(), 24): 10:57:47
Select CONVERT(varchar(100), GETDATE(), 108): 10:57:49
Select CONVERT(varchar(100), GETDATE(), 12): 060516 Select CONVERT(varchar(100), GETDATE(), 23): 2006-05-16 ......
