October 11, 2012 at 1:07 pm
Where and how would I go about reporting a typo in BOL? Specifically, this is for the code example for the ALTER DATABASE SPECIFICATION example. In BOL, it reads:
ALTER DATABASE AUDIT SPECIFICATION HIPPA_Audit_DB_Specification
FOR SERVER AUDIT HIPPA_Audit
ADD (SELECT
ON Table1(Column1)
BY dbo)
WITH STATE = ON;
GO
but the contents of the WITH keyword need to be surrounded in parentheses as detailed in Syntax section:
ALTER DATABASE AUDIT SPECIFICATION HIPPA_Audit_DB_Specification
FOR SERVER AUDIT HIPPA_Audit
ADD (SELECT
ON Table1(Column1)
BY dbo)
WITH (STATE = ON);
Yes, nitpicking I know!
October 11, 2012 at 3:37 pm
There should be a link at the bottom of each screen that enables you to provide feedback on the content.
October 11, 2012 at 8:17 pm
Providing a link to the BOL page might encourage the rest of us to join in.
October 11, 2012 at 9:00 pm
Did you test it to verify that this syntax does not work?
WITH STATE = ON
October 12, 2012 at 9:13 am
Yes. Further, I don't think it is possible to issue a database audit against an individual column even though the Syntax section indicates otherwise. Even if you try to create a database audit spec against an actual table/column combination, the following error is returned:
Msg 33211, Level 15, State 1, Line 0
A list of subentities, such as columns, cannot be specified for entity-level audits.
I will see about adding a comment to the BOL page as suggested. Thank you for the input everyone!
DH
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply