thank u everyone

raiserror wrks!!!!!!

alzdba select @cnt doesnt wrk

thank u for replying

my query is some thin g like this

declare @cnt int

set @cnt = 1

while (@cnt <220)

BEGIN

begin transaction

update D_outlet

set OUTLET_sid=OUTLET_sid

commit transaction

set rowcount 1

print @cnt

set @cnt = @cnt+1

end

The update...

please help meee!!!!!!

Hey use this piece of code

EXEC sp_dboption gl_rnd, 'trunc. log on chkpt.', 'True'

Checkpoint ...