Hi All
I am planning to create an audit for all my SQL Servers, i have something on my mind with the problems that i have faced earlier from SQL servers, so i am planning to take into account of the following
(i) Table Growth
(ii) Table Row Count
(iii) User Permissions
(iv) Index Fragmentation
(v) Check for New tables and databases.
i know that every one has got their own auditing systems or use a 3rd party tool or Profiler,
Can you please share your experience and help me create an ideal Auditing system so i don't have to relay on any other systems when problem happens,
I am using SQL 2005 on Windows 2K3 (64Bit) and i am planning to run this once a day
Please share your experiences 🙂
Cheers
🙂