CODEWITHSUNDEEP
sqlsql-serverdebuggingstored-procedureslogging
Tim Schmelter
Tim Schmelter

Reputation: 460038

"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 know on what step it is or if it is even actually running at all. MS SSMS says that it is still executing the query.

Thanks in advance, Tim

Upvotes: 1

Views: 892

Answers (2)

anishMarokey
anishMarokey

Reputation: 11397

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

Upvotes: 3

Beth
Beth

Reputation: 9607

Use Print statements?

Update a log table?

Upvotes: 0

Related Questions