@dbname varchar(30),
@segmentname varchar(30),
@space_left int,
@status int
as
declare @SpaceLeft varchar(20),
@Status varchar(20)
select @SpaceLeft=str(@space_left,6,0)
select @Status=str(@status,6,0)
print "Log is dumpped('%1!' for '%2!',SpaceLeft:'%3!',Status:'%4)',
and is dumped.",@segmentname,@dbname,@SpaceLeft,@Status
dump transaction tempdb to with truncate_only
return