|
kond.mohan
Posting Yak Master
India
154 Posts |
 Posted - 01/16/2013 : 02:00:04
|
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
|
|
|
James K
Flowing Fount of Yak Knowledge
1743 Posts |
Posted - 01/16/2013 : 06:34:20
|
| See if the standard report "Schema Changes History" gives you the information you are looking for. Right click the server name in object explorer, and select Reports, Standard Reports, Schema Changes History. |
 |
|
Sql server logs
