any idea on Event Log Generation in MS SQL 2005

Hi,

For the project which am working requires real time Audit logs. Can any one suggest me how to generate all the Audit logs or any website publishes all the logs related to MS SQL?? Any help is appreciated.

Regars,
Jags

Do you need to audit SQL Server activities for a database: Use SQL Profiler.

You may like visiting below link for C2 Level audit for Administrator's and User's Security:

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlc2.mspx
http://www.sqlservercentral.com/columnists/dasanka/basicsofc2auditing.asp

For SQL Server 2005, How to enable it? (check details from below link)
http://msdn2.microsoft.com/en-us/library/ms189114.aspx

Deepak Kumar
MVP, MCDBA - SQL Server

Disclaimer: This post is provided as is with no rights & warranty for accuracy, for the sake of knowledge sharing only.

Hi Deepak,
thanks a lot. I need few more details. Do you have any idea of how many Event categories present in MS-SQL 2005??? Do you have any dll's with which we can check for relevant Event Id's. Hoping for a quick reply.

Hi,
Does any body have idea of how SQL Server 2005 trace log format will be?? are there any tools to see trace file(apart from SQL Profiler)?? Any help is appreciated.

Rgds,
Jags

Tool:
http://www.apexsql.com/sql_tools_audit.asp
Lumigent Audit DB: http://lumigent.com/products/auditdb.html
http://www.apexsql.com/sql_tools_edit.asp
http://www.apexsql.com/blog/2006/08/sql-profiler-pre-announced.htm


SQL Profiler: Features, functions and setup in SQL Server 2005
http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1159433_tax301334,00.html?adg=301324&bucket=ETA

Deepak Kumar
MVP, MCDBA - SQL Server

Disclaimer: This post is provided as is with no rights & warranty for accuracy, for the sake of knowledge sharing only.

HI aditi,<br />you can also have a look at lumigient Log Explorer, an interesting tool, though a bit expensive.[<img src='/community/emoticons/emotion-1.gif' alt='' />]<br /><br />AKTHAR

I guess, below link is what you need, and it closely match your requirements:<br /><br /<a target="_blank" href=http://lumigent.com/products/auditdb_sql.html>http://lumigent.com/products/auditdb_sql.html</a><br /><br />[<img src='/community/emoticons/emotion-1.gif' alt='' />]<br /><br /><b>Deepak Kumar</b><br /><font size="1">MVP, MCDBA - SQL Server<br /><br />Disclaimer: This post is provided as is with no rights & warranty for accuracy, for the sake of knowledge sharing only.</font id="size1">

Thanks for adding the correct link deepak[<img src='/community/emoticons/emotion-2.gif' alt='' />]<br /><br />AKTHAR

Thanks Deepak and Akthar for your quick inputs. I can look in to it. But i need the foramt of SQL Server 2005 trace log. Can you please let me know.

Aditi,

See if the details below help, as Trace log can also be save a XML file

Profiler Trace Definitions: Profiler event trace definitions are saved as XML files (%ProgramFiles%Microsoft SQL Server90ToolsProfilerTraceDefinitions).


Profiler Trace XML File: Profiler allows saving trace results to an XML file (File | Save As | Trace XML File... or File | Save As | Trace XML File for Replay...)


AKTHAR

Small correction akthar..I Need Trace FILE format. I have trace log format.

Hi,

Is it possible to make a stored procedure run whenever SQL Server 2005 restarts? If so, please let me know the steps to do it.

Thanks,
Jags

quote:Originally posted by aditi

Hi,

Is it possible to make a stored procedure run whenever SQL Server 2005 restarts? If so, please let me know the steps to do it.

Thanks,
Jags

Well, you can schedule SQL Server Agent Jobs to run whenever SQL Server Agent Starts - that's not quite the same thing, but may be helpful.

Panic, Chaos, Disorder ... my work here is done --unknown

exec sp_procoption 'procedure', 'startup', 'true'

Nice ... I thought I remembered be something like that.

Panic, Chaos, Disorder ... my work here is done --unknown