Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
sql server 2008 log information details ..?

Answered sql server 2008 log information details ..?

  • Wednesday, January 16, 2013 7:03 AM
     
     
    Sign In to Vote
    0
    Hi,
    we are using Sqlserver 2008.we want know any modifications on Database level (example table creation,drop table,index creation,index drop,add or subtract colums to table.,column convertions.........all(any kind of operations on database table))
    information. i am not able to find all the information in Mangement node -->sql server logs (current) file.
    if any bodyknows how to capture the related information.or where it is stored. pls explatin detail
     

All Replies

  • Wednesday, January 16, 2013 7:14 AM
     
     Answered
    Sign In to Vote
    0

    Hello,

    The SQL Server log logs only error and dedicated action, but not any DDL command.

    The default logs some DDL commands, you can use the standard report to get the informations: SQL Server Management Studio Standard Reports – Schema Changes History

    Olaf Helper

    Blog Xing

     
  • Thursday, January 17, 2013 4:57 PM
     
     
    Sign In to Vote
    0

    If you have Enterprise or Developer edition you can use SQL Server Audit and create a database audit specification in the db in question to record these events.

    here's the link

    http://msdn.microsoft.com/en-us/library/cc280386(v=sql.105).aspx

    You could also achieve this by creating an event notification using the DDL_DATABASE_LEVEL_EVENTS  group to record or notify you of when these events happen.

    Ben