![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
SQL Server
文章平均质量分 57
winfor
.net初级选手
展开
-
SQL SERVER DBCC命令解释
SQL SERVER DBCC命令解释--1 dbcc trraceon DBCC TRACEOFF--对于数据库死锁,通常可以通过TRACE FLAG 1204、1205、1206,检查ERRORLOG里面的输出,和分析SQLTRACE的执行上下文判断死锁问题的来由。--TRACEON函数的第三个参数设置为-1,表示不单单针对当前connection,--而是针对所有包括转载 2012-11-10 21:07:49 · 446 阅读 · 0 评论 -
'Agent XPs' component is turned off as part of the security configuration for this server
'Agent XPs' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'Agent XPs' by using sp_configure. For more informa原创 2012-11-10 20:46:18 · 1504 阅读 · 0 评论 -
how to connect SQL servr by sqlcmd comment
cmdC:\>sqlcmd -S ANT-CN-ZHUWH1> use mysqldb2> select * from login_info;3> goChanged database context to 'MySQLDB'.UserID Password Us原创 2012-11-10 21:01:02 · 429 阅读 · 0 评论