Auditing All Activity

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Auditing All Activity

Auditing All Activity

Rate Topic

Display Mode

Topic Options

Author

Message

SwedishOrr

Posted Wednesday, December 17, 2008 11:46 AM

SSC Veteran

Group: General Forum Members
Last Login: Thursday, September 13, 2012 3:25 PM
Points: 205, Visits: 640

Hi all,

I'm running into Level17 and Level19 errors when those have never been popping up in the past. I know that I haven't made any major changes to SQL Server and to be safe, I rolled back the changes that I did make to be sure those changes weren't the cause of the errors.

The errors are still popping up and the unique piece of this puzzle is a lack of transparency and openness. I have a supervisor that does things on his own and refuses to keep anyone in the loop. Furthermore, when I ask questions, I don't feel like I get straight answers.

So, the only way I'm going to know if something changes that I don't do (yes, I document my work) is if I audit all activity on the server.

Does anyone know of an efficient way to do this? Any help at all is greatly appreciated.

Thank you so much in advance.

Post #621516

AlexSQLForums

Posted Wednesday, December 17, 2008 12:24 PM

Ten Centuries

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 6:53 AM
Points: 1,227, Visits: 1,712

for DDL.

from SSMS right click on db and select schema history changes report.

Alex S

Post #621540

bitbucket-25253

Posted Wednesday, December 17, 2008 4:11 PM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 7:13 PM
Points: 5,103, Visits: 20,214

You might also want to try:
fn_trace_gettable

as:

SELECT *
FROM fn_trace_gettable
('C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\log.trc', default)

The location above is the default location for traces, yours may have been altered.

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read
Before posting a performance problem please read

Post #621695

« Prev Topic | Next Topic »

Permissions