标题: 怎样解决SQL Server has run out of LOCKS. [打印本页] 作者: yyyy75 时间: 2004-03-29 11:16 标题: 怎样解决SQL Server has run out of LOCKS. 请问查询时出现以下信息，怎样清LOCKS呢？
SQL Server has run out of LOCKS. Re-run your command when there are fewer active users, or contact a user with System Administrator (SA) role to reconfigure SQL Server with more LOCKS.作者: yyyy75 时间: 2004-03-29 11:37 标题: 怎样解决SQL Server has run out of LOCKS. 怎样显示那些表锁定呢作者: yangblz 时间: 2004-03-29 11:49 标题: 怎样解决SQL Server has run out of LOCKS. 在配置文件中增加LOCK数量,然后重启数据库.最好找出原因,不要无休止地增加LOCK数量.作者: yyyy75 时间: 2004-03-29 12:09 标题: 怎样解决SQL Server has run out of LOCKS. 用什么命令可以看出那些表加锁了，并且被那些用户锁定，然后再KILL ？作者: chuxu 时间: 2004-03-29 12:31 标题: 怎样解决SQL Server has run out of LOCKS. sp_lock
sp_who作者: laoma1994 时间: 2004-03-29 14:58 标题: 怎样解决SQL Server has run out of LOCKS. --减少对锁资源的消耗
lock table tablename in exclusive mode作者: nicolewdc 时间: 2004-03-30 16:55 标题: 怎样解决SQL Server has run out of LOCKS. 可以将行锁改为表锁作者: solofeng 时间: 2004-04-01 15:35 标题: 怎样解决SQL Server has run out of LOCKS. sp_lock
sp_who作者: hu-yf 时间: 2004-04-01 16:32 标题: 怎样解决SQL Server has run out of LOCKS. 加锁好了。