Home Forums SQL Server 7,2000 T-SQL How can I show results while WHILE is running RE: How can I show results while WHILE is running

  • I would recommend using a user-defined trace, use Profiler Event "UserConfigurable:0" to watch it:

    
    
    DECLARE @DebugStr NVARCHAR(100)
    SET @DebugStr = @eventdate + ' ' + convert(varchar(6), @amount)
    -- Log Custom message to Profiler User Defined Event 0)
    EXEC sp_trace_generateevent 82, @DebugStr

    -Dan


    -Dan