We have a client running ISA2006 with logs going to MSDE.
The MSDE database gets rotated. We have NO control over the client infrastructure.
We need to get the logs out to a TEXT file on the server itself which will be forwarded to a remote server by other software we already have in place.
My first thought was doing it via Stored Procs. Another option is vbscript? The actual table holding the logs has no primary key or other identifier so I think the dump should be done once a day for the previous day, but ideally it should run several times a day.