为什么sqlserevermanagementstudio打开后会引起数据库阻塞
进程号SPID:3550被进程号SPID:2835阻塞,数据库为:tempdb,IP地址 进程名:Microsoft SQL Server Management Studio - Transact-主机名: 网卡地址 ,其当前进程执行的SQL语法如下
阻塞语句如下
SELECT
tr.name AS [Name],
tr.object_id AS [ID],
CAST(
tr.is_ms_shipped
AS bit) AS [IsSystemObject],
CASE WHEN tr.type = N'TR' THEN 1 WHEN tr.type = N'TA' THEN 2 ELSE 1 END AS [ImplementationType],
CAST(CASE WHEN ISNULL(smtr.definition, ssmtr.definition) IS NULL THEN 1 ELSE 0 END AS bit) AS [IsEncrypted]
FROM
sys.triggers AS tr
LEFT OUTER JOIN sys.sql_modules AS smtr ON smtr.object_id = tr.object_id
LEFT OUTER JOIN sys.system_sql_modules AS ssmtr ON ssmtr.object_id = tr.object_id
WHERE
(tr.parent_class = 0)
ORDER BY
[Name] ASC
1/如果SQL服务都启动,并且配置OK,就剩下网络的问题。2/在服务器名称栏位填写本机IP,身份验证选择windows身份验证试试。3/另外检查:打开[SQL Server 配置管理器]<在运行中输入SQLServerManager.msc回车>-->双击[SQL Server]服务-->打开[属性]对话框,检查登录身份是否为本地系统。如果不是选择内置账户,local system。-->重启sql服务。
下一篇:电脑输入错乱