在MS Sql Server中运行存储过程的“调试”(获取信息) [英] "Debug"(get information) on a running stored procedure in MS Sql Server
本文介绍了在MS Sql Server中运行存储过程的“调试”(获取信息)的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
提前感谢
Tim
解决方案
sql Profiler可以帮助您: http://www.databasejournal.com/features/mssql/article.php/3750161/Introduction-to-SQL-2005-Profiler-Part-1.htm
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
解决方案
sql Profiler can help you: http://www.databasejournal.com/features/mssql/article.php/3750161/Introduction-to-SQL-2005-Profiler-Part-1.htm
这篇关于在MS Sql Server中运行存储过程的“调试”(获取信息)的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文