Need to audit structure change

How to audit changes made by SQL users on table
structure. Some changes include data type, column name,
and number of columns.
Thanks for suggestion.Look up sp_trace_create in the books online - one of the security audit
event types will allow you to capture all DDL which should get everything
you're looking for here. You can also use sql profiler to build the trace
for you and then script it out if you don't want to use the GUI all the
time...
Richard Waymire, MCSE, MCDBA
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jim Fuller" <anonymous@.discussions.microsoft.com> wrote in message
news:020801c3ba8a$69ee1650$a101280a@.phx.gbl...

quote:

---

> How to audit changes made by SQL users on table
> structure. Some changes include data type, column name,
> and number of columns.
> Thanks for suggestion.

---

Need Info on Tools for MSSQL Reporting etc.

Hi All,

Am looking for inputs on tools for MSSQL. Some of my requirements are

1) Database Audits or to audit database settings and Logins
2) Performance Monitoring
3) Query Tuning
4) Data Compare
5) Load Testing - to see how an sql instance/server reacts to higher load/volume.

I am looking for reviews/web-links from any first-hand experience wherever possible.

TIA,

Warm Regards,
Ranjit.redgate has many excellent tools for sql server. their data compare tool is quite good. www.red-gate.com

Friends of mine like the tools from ApexSQL, but I haven't used them much.

BPA is a free tool from MS for analyzing server settings for "best practices" (like blank sa password, etc).

Finally, a plug for my own too: if you have a need for documenting your databases, you might check out sqlspec, a tool I wrote myself at the link in my sig below. :}