service name
里填写你的 服务名(easy config 里配的)
里填写你的 服务名(easy config 里配的)
解决方案 »
- 谁能给我一个订单提交的代码?3Q
- SQL数据库开发
- 如何查看数据库当前的一些设置值呢(如: set ansi_nulls,set quoted_identifier 等)
- 如何最快得得知某列不允许为空?
- 我想编程实现对SQL server 添加实例,不知哪位高手做过,送分100
- SQL 怎么当月第一天,第几周,月最后一天
- SQL Server does not exist or access denied 问题
- 数据库高深问题。(高手请进)
- 请教关于ESQL\C入门问题?
- 十万火急!!!如何进行数据备份
- 急!!如何清空SQL Server中所有用户自己建的表的数据?
- 哪里有oracle ocp认证考试的测试题目下载?
2.sp_lock是系统存储过程如果不行,先检查一下master库下stored procedure中有没有sp_lock,如果没有用以下脚本创建它.create procedure sp_lock --- 1996/04/08 00:00
@spid1 int = NULL, /* server process id to check for locks */
@spid2 int = NULL /* other process id to check for locks */
asset nocount on
/*
** Show the locks for both parameters.
*/
if @spid1 is not NULL
begin
select convert (smallint, req_spid) As spid,
rsc_dbid As dbid,
rsc_objid As ObjId,
rsc_indid As IndId,
substring (v.name, 1, 4) As Type,
substring (rsc_text, 1, 16) as Resource,
substring (u.name, 1, 8) As Mode,
substring (x.name, 1, 5) As Status from master.dbo.syslockinfo,
master.dbo.spt_values v,
master.dbo.spt_values x,
master.dbo.spt_values u where master.dbo.syslockinfo.rsc_type = v.number
and v.type = 'LR'
and master.dbo.syslockinfo.req_status = x.number
and x.type = 'LS'
and master.dbo.syslockinfo.req_mode + 1 = u.number
and u.type = 'L'
and req_spid in (@spid1, @spid2)
end/*
** No parameters, so show all the locks.
*/
else
begin
select convert (smallint, req_spid) As spid,
rsc_dbid As dbid,
rsc_objid As ObjId,
rsc_indid As IndId,
substring (v.name, 1, 4) As Type,
substring (rsc_text, 1, 16) as Resource,
substring (u.name, 1, 8) As Mode,
substring (x.name, 1, 5) As Status from master.dbo.syslockinfo,
master.dbo.spt_values v,
master.dbo.spt_values x,
master.dbo.spt_values u where master.dbo.syslockinfo.rsc_type = v.number
and v.type = 'LR'
and master.dbo.syslockinfo.req_status = x.number
and x.type = 'LS'
and master.dbo.syslockinfo.req_mode + 1 = u.number
and u.type = 'L'
order by spid
endreturn (0) -- sp_lock