Audit information in to table

Question

Audit information in to table

New persopn

SSCarpal Tunnel

Points: 4019
More actions
April 26, 2016 at 12:33 pm

#400074

Hi All,
As per client request we are capturing Server level audit information to File. Now they want file information needs to be in table format.
Can someone please guide me how can we capture the Audit information to table.

Viewing 13 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic. Login to reply

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

New persopn (4/26/2016)
Hi All,
As per client request we are capturing Server level audit information to File. Now they want file information needs to be in table format.
Can someone please guide me how can we capture the Audit information to table.

BULK INSERT, SSIS, just to name a couple.

New persopn SSCarpal Tunnel Points: 4019 More actions · Answer 2

New persopn

SSCarpal Tunnel

Points: 4019

April 26, 2016 at 12:46 pm

#1874762

If any references please share

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 3

New persopn (4/26/2016)
Hi All,
As per client request we are capturing Server level audit information to File. Now they want file information needs to be in table format.
Can someone please guide me how can we capture the Audit information to table.

How are you capturing the information now?

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 4

Start with Books Online, the SQL Server Help system. There is a lot of information there to get you started.

New persopn SSCarpal Tunnel Points: 4019 More actions · Answer 5

Currently I am capturing Audit information in to file.

New persopn SSCarpal Tunnel Points: 4019 More actions · Answer 6

New persopn

SSCarpal Tunnel

Points: 4019

April 26, 2016 at 12:50 pm

#1874767

I am not getting any references in online

Luis Cazares SSC Guru Points: 183698 More actions · Answer 7

New persopn (4/26/2016)
Currently I am capturing Audit information in to file.

How?

What are you auditing?

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 8

New persopn (4/26/2016)
Currently I am capturing Audit information in to file.

I didn't where. I asked how?

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 9

New persopn (4/26/2016)
I am not getting any references in online

https://msdn.microsoft.com/en-us/library/hh994726(v=sql.10).aspx

New persopn SSCarpal Tunnel Points: 4019 More actions · Answer 10

We are capturing Server level information in to file through SQL Audit option

Lowell SSC Guru Points: 323504 More actions · Answer 11

SQL Server Import and Export Wizard

https://msdn.microsoft.com/en-us/library/ms141209.aspx

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Luis Cazares SSC Guru Points: 183698 More actions · Answer 12

New persopn (4/26/2016)
I am not getting any references in online

Check this article: http://weblogs.sqlteam.com/jeffs/archive/...er.aspx

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2