ITPub博客

1、在安装向导过程中，出现如下错误：{英文原意如下When you install Microsoft SQL Server 2005, you receive the following error message: There was an unexpected failure during the setup wizard. You may review the setup logs and/or click the help button for more information.}[@more@]2、当我检查C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSummary.txtMicrosoft SQL Server 2005 9.00.1399.06 ============================== OS Version : Microsoft Windows Server 2003 family, Enterprise Edition Serv

--查询哪个查询阻塞了其他的查询SELECTblocked_query.session_id AS blocked_session_id,blocking_query.session_id AS blocking_session_id,sql_text.text AS blocking_text,waits.wait_type AS blocking_resourceFROM sys.dm_exec_requests blocked_queryJOIN sys.dm_exec_requests blocking_query ON blocked_query.blocking_session_id = blocking_query.session_idCROSS APPLY (SELECT * FROM sys.dm_exec_sql_text(blocking_query.sql_handle) ) sql_textJOIN sys.dm_os_waiting_tasks waits ON waits.session_id = blocking_query.

启用sqlserver2005是快照隔离，方法如下：ALTER DATABASE YourDataBaseName SET ALLOW_SNAPSHOT_ISOLATION ON;ALTER DATABASE YourDataBaseName SET READ_COMMITTED_SNAPSHOT ON;[@more@]