错误提示SQL Server has run out of LOCKS.该怎么解决?
Posted on 八月 16rd, 2007 由 admin
我欲在有记录大约有9万条的表建索引,用语句
create clustered index biblio on biblio ( recid, marcnum )
系统工作一段时间后提示:
msg 1204, level 19, state 1
sql server has run out of locks. re-run your command when there are fewer active users, or ask your system administrator to reconfigure sql server with more locks.
怎么回事?是不是记录太多了?该怎么解决,急呀,谢谢大家先。
推荐阅读


讨论区