при попытке выполнить update index statistics возникает , следующая ошибка... ... говорится

server Stored
procedure 'sp_thresholdaction' not found. Specify
owner.objectname or use sp_help to check whether the
object exists (sp_help may produce lots of output).
server Spaceavailable in the log segment has fallen critically low in
database 'tempdb'. All future modifications to this
database will be suspended until the log is successfully
dumped and space becomes available.


я попытался создать sp_thresholdaction

create procedure sp_thresholdaction
@dbname varchar(30),
@segmentname varchar(30),
@space_left int,
@status int
as
dump transaction @dbname to "/db"


после очередного выполнения update index statistics получаю следующее

SQL Server Message: Space available in the log segment has fallen critically low in database 'tempdb'. All future modifications to this database will be aborted until the log is successfully dumped and space becomes available. (sev 0, MsgNo 7412, lineNo 1)
SQL Server Message: Can't allocate space for object 'syslogs' in database 'tempdb' because 'logsegment' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment. (sev 17, MsgNo 1105, lineNo 1)
SQL Server Message: Can't allocate space for object 'temp worktable' in database 'tempdb' because 'system' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment. (sev 17, MsgNo 1105, lineNo 1)
SQL Server Message: Failed to insert row into worktable, when projecting base table on to work table for collecting statistics. (sev 18, MsgNo 1764, lineNo 1)
Server returns a FAIL status.
Execution of script aborted !

подскажите в чем проблема.. или скажите как граммотно создать эту процедуру