且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何监视SQL Server 2005上已执行的sql语句

更新时间:2022-03-07 02:15:38

看到您如何使用Management Studio Express,我将假定您无权使用MSSQL 2005客户端工具.如果这样做,请安装它们,因为它包括SQL Profiler,它可以完全满足您的要求(甚至更多!).有关该信息的更多信息,请参见 msdn .

Seeing how you use the Management Studio Express, I will assume you don't have access to the MSSQL 2005 client tools. If you do, install those, because it includes the SQL profiler which does exactly what you want (and more!). For more info about that one, see msdn.

前一段时间,我发现,因为我在考虑完全相同的事情.我本人可以访问客户端工具,因此我确实不需要,但是访问不是无限的(这是我目前的工作).如果您尝试一下,请告诉我它是否有效;-)

I found this a while ago, because I was thinking about the exact same thing. I have access to the client tools myself, so I don't really need to yet, but that access is not unlimited (it's through my current job). If you try it out, let me know if it works ;-)