I want to debug a lengthy stored procedure in SQL Server 2005 which uses lot of Table variables and temporary tables and produces output finally.
Its been difficult to analzye what each query's data would be like.
Is there a way I could write it a file or something to see what data each query would produce. .. I am aware to use print statements for variables etc, but for Data being retrieved by all these temporary tables etc how could we know what data is being retrieved.