Thanks Sue. However, I dont want to track the autogrowths of tempdb database but I want to track the tempdb allocations per query so that I can try optimizing queries...

Thank you,.

Any thoughts on how to find out the culprit row?

Does any trace / extended evet session help ??????

All that the stored proc is doing is below.

create proc <procname>
as
begin  

insert into staging_tbl
select c1,c2,c3,c4.......c50 from <LinkedServer>.<db1>.dbo.table

end

Please forget about the datawarehouse load. Assume , it tsql table and above INSERT , how can I figured out what column in the table causing the String Truncation error...

Thanks a lot for the help Chris.

Thanks a ton Erik.

Awesome Sir! Thank you very very much. This one is quite a daunting task for me.
Good day.

Yes.

I am sorry for the confusion. Basically the output of sql server is stored in the $results variable.
This is the one I want to render in nice html...

Any help?

Sir, at this point I am not looking to delete data from msdb.

Hi John,

Thanks for the response.

Yeah, I can do that but I want to limit those rows before itself.

Thanks mrrobsewell & Leonard. Both solutions are good. thank you.

@mrrobsewell - I need a small help. Considering Leonard solution, how can format in such a way so that Report,...