SQL Audit For MS SQL Server 2000

[joelk111]

Hello,

I need to do a performance audit for a SQL Server 2000 database which would
include the basics like CPU Usage, size, exc. I am going to put this into a CF
report that will email to me once daily.

Does anyone have the T/SQL code for an audit of that type?

Thanks!

Joel

[kim il sung]

this is not ad,

maybe SQLtool from Idera
[url]http://www.idera.com/Products/SQLtool/Features.aspx[/url]

check also free SQLcheck tool
[url]http://www.idera.com/Products/SQLcheck/Default.aspx[/url]

cheers
Kim

[The ScareCrow]

But, if you want to do your own.

Check out [url]http://www.sqlservercentral.com/[/url]

You may need to become a member, then search and you will find heaps of code and tutorials

Ken