blocks|key|1531203|text|您可以记录更改。SQL+Server+2008将通过变更数据捕获使这一点变得特别容易。但是SQL+Server并不擅长记录选择。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1531204|从理论上讲，分析器可以做到这一点，但它会扼杀您的性能。你可能会在你的桌面上“逃脱惩罚”，但我想你会注意到你的机器运行得很慢，足以导致问题。而且在任何类型的部署之后，它肯定都不会工作。|1531205|其他几个人已经忽略了一个重要的点:除非他们为2008年做了一些我没有听说过的事情，否则你不能触发SELECT。|1531206|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

You can log changes. SQL Server 2008 will make this especially easy with Change Data Capture. But SQL Server isn't very good at logging SELECTs. 

It is theoretically possible with the profiler, but it will kill your performance. You might "get away with it" on your desktop, but I think you'll notice your machine acting slow enough to cause problems. And it definitely won't work after any kind of deployment.

One important point a couple others have missed already: unless they changed something for 2008 I didn't hear about, you can't trigger a SELECT.

blocks|key|1746212|text|我会使用触发器或使用第三方软件，如Red+Gate来检查您的SQL日志文件。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1746213|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I would either use triggers or use a third party software such as Red Gate to check out your SQL log files.

blocks|key|1746262|text|看起来您可以使用T-SQL创建跟踪|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1746263|http://support.microsoft.com/kb/283790/|offset|length|1746264|这可能会有帮助。|1746265|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|13|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@$D|Q|E|R|1|S]]|A|$]]|$1|F|3|G|5|6|7|T|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|U|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|C]]]]

Seems that you can create traces using T-SQL 

<a href="http://support.microsoft.com/kb/283790/" rel="nofollow noreferrer">http://support.microsoft.com/kb/283790/</a>

That might help.

blocks|key|1531349|text|…回答晚了，但我希望它能对这里的其他读者有所帮助…|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1531350|除非只在开发环境中使用SQL+Server+Express，否则使用具有高级审核要求的SQL+Server+Express并不是真正的最佳选择。|1531351|您可以使用traces+(www.broes.nl/2011/10/profiling-on-sql-server-express/)来获取所需的数据，但您必须自己解析这些数据。|1531352|有第三方工具可以做到这一点，但它们的成本将相当高。来自ApexSQL的Log+explorer可以记录除select之外的所有内容，Idera’s遵从性管理器也会记录select语句，但它的成本要高得多。|offset|length|1531353|entityMap|0|LINK|mutability|MUTABLE|url|http://www.apexsql.com/sql_tools_log.aspx|1|http://www.idera.com/^0|0|0|0|Z|C|0|1U|7|1|0^^$0|@$1|2|3|4|5|6|7|T|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|U|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|V|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|W|8|@]|9|@$H|X|I|Y|1|Z]|$H|10|I|11|1|12]]|A|$]]|$1|J|3|-4|5|6|7|13|8|@]|9|@]|A|$]]]|K|$L|$5|M|N|O|A|$P|Q]]|R|$5|M|N|O|A|$P|S]]]]

…Late answer but I hope it would be useful to other readers here…

Using SQL Server Express with advanced auditing requirements such as this is not really optimal unless it’s only in development environment. 

You can use traces (www.broes.nl/2011/10/profiling-on-sql-server-express/) to get the data you need but you’d have to parse these yourself. 

There are third party tools that can do this but their cost will be quite high. <a href="http://www.apexsql.com/sql_tools_log.aspx">Log explorer</a> from ApexSQL can log everything but select and <a href="http://www.idera.com">Idera’s</a> compliance manager will log select statements as well but it’s cost is a lot higher.

blocks|key|1531387|text|还有一种方法可以获取有关已在MS+SQL+Server+Express+described+here上执行的查询的信息。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1531388|简而言之，它对系统表运行智能查询，并获取有关查询的信息(文本、执行时间)(如果需要，还可以获取缓存的查询计划)。因此，在MSSQL2008Express版中，您可以在没有事件探查器的情况下获得有关已执行查询的信息。|1531389|SELECT+deqs.last_execution_time+AS+[Time],+dest.TEXT+AS+[Query]
FROM+sys.dm_exec_query_stats+AS+deqs
CROSS+APPLY+sys.dm_exec_sql_text(deqs.sql_handle)+AS+dest
ORDER+BY+deqs.last_execution_time+DESC|code-block|syntax|javascript|1531390|entityMap|0|LINK|mutability|MUTABLE|url|http://blog.sqlauthority.com/2008/01/03/sql-server-2005-last-ran-query-recently-ran-query/^0|10|E|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@$A|T|B|U|1|V]]|C|$]]|$1|D|3|E|5|6|7|W|8|@]|9|@]|C|$]]|$1|F|3|G|5|H|7|X|8|@]|9|@]|C|$I|J]]|$1|K|3|-4|5|6|7|Y|8|@]|9|@]|C|$]]]|L|$M|$5|N|O|P|C|$Q|R]]]]

There is one more way to get information about queries that has been executed on MS SQL Server Express <a href="http://blog.sqlauthority.com/2008/01/03/sql-server-2005-last-ran-query-recently-ran-query/" rel="noreferrer">described here</a>.

Briefly, it runs smart query to system tables and gets info(text, time executed) about queries(or cached query plans if needed). Thus you can get info about executed queries without profiler in MSSQL 2008 Express edition.

<pre><code>SELECT deqs.last_execution_time AS [Time], dest.TEXT AS [Query]
FROM sys.dm_exec_query_stats AS deqs
CROSS APPLY sys.dm_exec_sql_text(deqs.sql_handle) AS dest
ORDER BY deqs.last_execution_time DESC
</code></pre>

Is there a way to tell SQL Server 2008 Express to log every query (including each and every SELECT Query!) into a file?

It's a Development machine, so the negative side effects of logging Select-Queries are not an issue.

Before someone suggests using the SQL Profiler: This is not available in Express (does anyone know if it's available in the Web Edition?) and i'm looking for a way to log queries even when I am away.

Logging ALL Queries on a SQL Server 2008 Express Database?

日志文件

SQL Server

有没有办法让SQL Server 2008 Express记录每个查询(包括每个SELECT查询！)到一个文件里？它是一台开发机器，所以记录Select-Queries的负面影响不是问题。在有人建议使用SQL Profiler之前:这在Express中不可用(有人知道它在Web版中是否可用吗？)我正在寻找一种即使我不在...

问是否记录SQL Server 2008 Express数据库上的所有查询？
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问是否记录SQL Server 2008 Express数据库上的所有查询？EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问是否记录SQL Server 2008 Express数据库上的所有查询？
EN