• I don't know if it can help you, but instead of using for xml, on SQL 2000 you can format the html by using:

    declare @tsql nvarchar(4000)

    set @tsql=''

    Select @tsql = @tsql + '<tr><td>' + name + '</td>' + '<td>' + product + '</td>' + '<td>' + provider+ '</td>' + '<td>' + data_source + '</td>' + '<td>' + is_linked + '</td></tr>'

    From sys.servers

    select @tsql