如何在sql server中的复杂过程中创建日志文件 [英] How to create log file in complex procedure in sql server

问题描述

嗨

我想为复杂程序制作日志，这样我就可以在SQl Server中找到数据或步骤中的确切问题。我知道有事务日志文件，但我想查找输出特定程序的日志和数据后面的步骤。由于事务日志在服务器端，我们无法访问，它包含整个事务日志。

还有其他方法吗。

提前致谢

Hi
I want To make log for Complex procedure so that I can find out exact problems in data or steps followed in SQl Server.I know that there is transactional log file but I want to find out logs for specific procedure and steps followed with data.As transactional log is on server side we cannot have access and it consists of whole transactional log.
Is there any other way for this.
Thanks in advance

推荐答案

检查一下。我不熟悉SQL跟踪。五月或五月对您的要求无效。



http ：//technet.microsoft.com/en-us/library/ms191006（v = sql.105）.aspx [ ^ ]

Check this. I am not familiar with SQL trace. May or May not be useful to your requirement.

http://technet.microsoft.com/en-us/library/ms191006(v=sql.105).aspx[^]

这篇关于如何在sql server中的复杂过程中创建日志文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！