Debugging Stored Procedure - TimeStamp

[not4google]

Hi all,

I have a huge Stored Proc (T-SQL) that I need to get some information on. I want to put in print statements at specific points of the procedure to get back the timestamp,

How can I get the timestamps of specific points?

GETDATE()?

Thanks for any suggestions,

 

[not4google]

Currently I have the following which seems pretty useful:

SET STATISTICS TIME ON
--Code here
SET STATISTICS TIME OFF

 

[gmmastros]

At strategic points within the code, you could put...

Print 'Here: ' + Convert(VarChar(30), GetDate(), 121)

Print statements get put in to the 'messages' tab with Query Analyzer and the new Management Studio.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom