Im 使用 SQL 2008, 并在表格 XYZ 上启用了 DELETE、 UPDATE & amp; INSERT 审计。 除了我查询数据外, 工作效果很好 :
SELECT * FROM fn_get_audit_file( H:SQLAudits* , default, default)
它实际上没有向我显示什么被删除、插入或更新过,只有删除了,等等。 以上查询的语句栏显示此片段 :
delete [dbo].[XYZ] where ([Name] = @0)
我希望它能让我知道 @0的价值是什么。有办法这样做吗?
从我所发现的情况来看, SQL Server 2008 的“ 审计” 功能非常缺乏。 它不是一种传统的数据审计线索。 每次有变化( 通过 Triggers), 你都会储存一列新的数据审计线索, 并存有完整的信息, 比如做出改变的用户。 它或多或少只是告诉您一些变化没有太多细节。 我希望 SQL Server 包含完整的数据审计线索功能 。
http://blogs.msdn.com/b/manisblog/archive/2008/07/21/sql-server-server- 2008- auditting.aspx" rel=“nofollow” >Reference
虽然 Create数据库审计规格 ,但您为 Audit Action 类型 INSERT 、 UPDATE 、 DELETE 选择操作。
这导致显示我们的日志, 表示 < code> 选择或插入、 插入或更新或删除 ... 但无法看到单个值 。
http://blogs.msdn.com/blogfiles/manisblog/WindowsLiveWriter/SQLServer2008Auditting_3C87/Audit27_2.jpg" rel=“nofolpt” >Example - 点击这里查看插入的日志/更新/ Delete
“强”SQL服务器审计
为此,您将需要 < 强势 > 变化数据捕获 http://msdn.microsoft.com/en-us/library/bb522489.aspx )。
Cheers, Mark
You can monitor the delete sentences using SQL Server Profiler. You will be able to see the changes. Another way to monitor is using the CDC (Change Data Capture) feature in SQL Server. This feature will let you monitor changes in the tables.
最后,还有其他工具,如ApexSQL Trigger。
I noticed that there were some threads with similar questions, and I did look through them but did not really get a convincing answer. Here s my question: The subquery below returns a Table with 3 ...
I m 查询Oracle 10g。 我有两张表格(样本数据见下文)。 i m 试图提取一些领域
We have a restaurant table that has lat-long data for each row. We need to write a query that performs a search to find all restaurants within the provided radius e.g. 1 mile, 5 miles etc. We have ...
What are some cool SQL shorthands that you know of? For example, something I learned today is you can specify to group by an index: SELECT col1, col2 FROM table GROUP BY 2 This will group by col2
I have an array of output from a database. I am wondering what the cleanest way to filter the values is example array Array ( [0] => Array ( [title] => title 1 ...
we have a table in an Oracle Database which contains a column with the type Char(3 Byte). Now we use a parameterized sql to select some rows with a DBNull.Value and it doesn t work: OracleCommand ...
I have a SQL-statement like this: SELECT name FROM users WHERE deleted = 0; How can i create a result set with a running number in the first row? So the result would look like this: 1 Name_1 2 ...
I’m developing an application dedicated to generate statistical reports, I would like that user after saving their stat report they save sql queries too. To do that I wrote the following module: ...