急急急!!!
jamex 2000-08-04 04:35:00 请问,俩个问题,谢谢:
1. 请问如何使sql server db的transaction log文件大小减小,我的.ldf文件已经有750M(我想变为100M左右),救救我吧!!! 清日志的方法我用过,但是还是无法减小.ldf的文件大小,该怎么办???
2.
请问为什么我的asp代码调用stored proc返回的recordset是adOpenForwardOnly的???
具体asp代码如下:
dim sql,rs,cmd,para
Const adCmdStoredProc = &H0004
set cmd=server.CreateObject("adodb.command")
set cmd.ActiveConnection =conn
cmd.CommandType= adCmdStoredProc
BoardId=12
set rs=server.createobject("adodb.recordset")
rs.CursorType =adOpenKeyset
rs.LockType =1
cmd.CommandText ="proc_GetBoard"
Set para = cmd.CreateParameter("BoardId", 3, &H0001)
cmd.Parameters.Append para
para.Value = BoardId
rs.Open cmd
rs.movefirst (报错)
stored proc 如下:
CREATE PROCEDURE proc_getboard @BoardId int AS
declare @a char(2)
select @a=ltrim(str(@BoardId))
EXEC('select AnnounceID,boardID from GetBoard' + '12' + ' ORDER BY announceID desc')
rs返回的为什么是adOpenForwardOnly类型的????
该如何解决???
大虾救我!
您真挚的,
jamex