SQL Server Performance

any idea on Event Log Generation in MS SQL 2005

Discussion in 'SQL Server 2005 General DBA Questions' started by aditi, Aug 14, 2006.

  1. aditi New Member

    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
  2. Luis Martin Moderator

    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.



  3. deepakontheweb New Member

    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.
  4. aditi New Member

    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.
  5. satya Moderator

  6. aditi New Member

    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
  7. deepakontheweb New Member

    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.
  8. Akthar New Member

    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
  9. deepakontheweb New Member

    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">
  10. Akthar New Member

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

    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.
  12. Akthar New Member

    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
  13. aditi New Member

    Small correction akthar..I Need Trace FILE format. I have trace log format.
  14. aditi New Member

    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
  15. SQL_Guess New Member

    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
  16. Adriaan New Member

    exec sp_procoption 'procedure', 'startup', 'true'
  17. SQL_Guess New Member

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

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

Share This Page