Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kond.mohan
Posting Yak Master
213 Posts |
 Posted - 2013-01-16 : 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
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-01-16 : 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. |
 |
|
|
lopez
Starting Member
8 Posts |
|
|
|
|
|
Sql server logs