"debug"(get Information) On A Running Stored Procedure In Ms Sql Server

i aked myself if it is possible in MS SQL-Server 2005 to get information of a running stored procedure. Because meanwhile it is executing for more than 8 hours, i would like to kno

Solution 1:

sql Profiler can help you: http://www.databasejournal.com/features/mssql/article.php/3750161/Introduction-to-SQL-2005-Profiler-Part-1.htm

Solution 2:

Use Print statements?

Update a log table?