SQL Server Performance Forum – Threads Archive

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

I’ve moved to relevant forum.
Luis Martin
Moderator
SQL-Server-Performance.com All in Love is Fair
Stevie Wonder
All postings are provided â€œAS ISâ€ with no warranties for accuracy.

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.

Again Books online would help you in this regard,http://msdn2.microsoft.com/en-us/library/ms191148.aspx fyi. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.

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, 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=’

‘ />] AKTHAR

I guess, below link is what you need, and it closely match your requirements: http://lumigent.com/products/auditdb_sql.html</a> [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] 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.

Thanks for adding the correct link deepak[<img src=’/community/emoticons/emotion-2.gif’ alt=’

‘ />] 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

]]>