October 11, 2013 at 9:09 am
Hi there - I have recently created an auditing process using the Audit functionality in SQL Server 2008r2. After creating and enabling my audit task I went to check on my output log however the log is formatted very strangely. I have copied a sample of what he file looks like below. Is there anything I can do to ensure my Audit logs information in a readable format? Thanks!!
Ì €³ ò&R¶ §¥/»w©Î AUSC 9 A š (  ( ê ² c8 < a c t i o n _ i n f o x m l n s = " h t t p : / / s c h e m a s . m i c r o s o f t . c o m / s q l s e r v e r / 2 0 0 8 / s q l a u d i t _ d a t a " > < s e s s i o n > < ! [ C D A T A [ A u d i t - 2 0 1 3 0 9 0 4 - 1 5 0 4 3 8 $ A ] ] > < / s e s s i o n > < a c t i o n > e v e n t e n a b l e d < / a c t i o n > < o b j e c t > < ! [ C D A T A [ a u d i t _ e v e n t ] ] > < / o b j e c t > < / a c t i o n _ i n f o > M 0 Ì G 4èm¶ x÷x©Î SL 9 Œñ
, [ P r i m a r y I D ]
, [ 2 9 1 3 2 7 1 3 - D F D E - 4 B 4 D - A C 4 D - B 8 3 B 2 6 8 1 3 2 D 6 ]
, [ 7 B F 4 8 9 B 7 - 0 F 3 7 - 4 B 7 2 - A 9 6 9 - E 9 1 4 3 D C B 2 9 E B ]
, [ 0 4 D 0 B 4 C 6 - 6 5 C 1 - 4 3 0 7 - 9 B D F - 8 2 F F 5 A 3 0 6 6 2 8 ]
, [ 2 8 C D C 0 2 C - B 5 6 1 - 4 D 7 7 - 8 A 3 2 - 4 C 8 D E 2 D 1 1 D F 4 ]
, [ 3 3 F A 2 7 3 2 - 8 1 0 6 - 4 3 A 4 - B 6 2 A - 3 6 6 3 D 4 A 2 E E 9 1 ]
, [ 6 7 6 9 4 8 7 2 - 0 3 E F - 4
--------------------------------------------
Laughing in the face of contention...
October 11, 2013 at 9:27 am
you can users either SSMS or t-sql to view the logs.
October 11, 2013 at 9:31 am
Thanks a lot Bob - Didn't release that option was there.
Have a nice weekend!
--------------------------------------------
Laughing in the face of contention...
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply