p; data = convert(char(10), convert(varchar(11),
convert(numeric(11,0),sum(data) / 1024 * low))
+ " " + "KB"),
index_size = convert(char(10), convert(varchar(11),
convert(numeric(11,0),sum(index_size) / 1024 *
low)) + " " + "KB"),
unused = convert(char(10), convert(varchar(11),
convert(numeric(11,0), sum(unused) / 1024 *
low)) + " " + "KB")
from #pagecounts
group by name
end
return (0)
go
if object_id('sp_showfrag') is not null
begin
print '<<< Created procedure dbo.sp_showfrag >>>'
grant execute on dbo.sp_showfrag to public
end
else
begin
print '<<< Failed creating proc dbo.sp_showfrag >>>'
end
go
zhangyh123 回复于：2003-06-18 17:07:39
-- 获取系统中正在执行transaction 的进程(ZT)
dump tran sybsystemprocs with truncate_only
go
use sybsystemprocs
go
if exists (select * from sysobjects where name = "sp_opentran" and type = 'P')
drop proc sp_opentran
go
create procedure sp_opentran
as
select spid, username=convert(varchar(12),suser_name(suid)),
tran_name=convert(varchar(25),tran_name),
dbname=convert(varchar(12),db_name(dbid))
from master..sysprocesses where tran_name > ' '
go
if object_id('sp_opentran') is not null
begin
print '<<< Created procedure dbo.sp_opentran >>>'
grant execute on dbo.sp_opentran to public
end
else
begin
print '<<< Failed creating proc dbo.sp_opentran >>>'
end
go
Blackrose 回复于：2003-06-18 19:33:38
弓虽啊！
:)
不过大家在生产系统使用的化 最好先坐坐充分的测试
存储过程也就是一种程序，难免有些bug哦
zhangyh123 回复于：2003-08-26 10:52:54
这个帖子沉下去了，可惜
小无赖 回复于：2004-03-06 15:17:22
顶！
上一页 [1] [2] [3] [4] [5] [6] |
