I need to find the file size of Windows logs(Application ,security & system) Using TSQL script.
I have Both environments (MSSQL 2000 & 2005). I want to set the alert when these files grow beyond certain limit.
I know that there is provision itself in it to overwrite the events, but still I want to set alerts on it using MSSQL.
I have tried with code below.
But its not working on every server I have, that is because of some AD issues (permission on the 'config' folder).
Please let me know is there any other way to do the same.
Thanks in advance.