Server-Side Trace Enhancements

I have decided that I needed to modify my trace file name to include date and time in a further attempt to make my file name unique. See below snippet:-


-- Build File Name

select @hr = datepart(hh,getdate())

select @min = datepart(mi,getdate())

select @sec = datepart(ss,getdate())

set @time = convert(char(2),@hr) + convert(char(2),@min) + convert(char(2),@sec)

set @filedate = CONVERT(char(8),getdate(),112)

If @Hr = '12'

set @filename = @path + 'Activity_' + @filedate

Else

set @filename = @path + 'Activity_' + @filedate + '_' + @time

End


This works in part. However, when the time has a zero in it, the program will substitue the zero with a blank.

Can someone suggest a better method