Wednesday, January 16, 2013 7:03 AMHi,
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
Wednesday, January 16, 2013 7:14 AM
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 HelperBlog Xing
- Marked As Answer by Eileen ZhaoMicrosoft Contingent Staff, Moderator Monday, January 28, 2013 5:28 AM
Thursday, January 17, 2013 4:57 PM
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
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.