If you are working with SQL Server 2005 then you can make use of DDL triggers to capture the details you have mentioned above. This will be simple and will fire only when there is any modification to the table schema!
Are you using 2005, this is a intresting question, i am wondering that there will be some DMV's on 2005, if you are using a performance dashboard then you can have this option on the trace file if you have altered the trace and saved them
🙂
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply