Ok this is the scenario. I have an ISA Server that sends all its logs to an
SQL 200 database. 3 databases as a matter of fact for each service which are
fwsrv, pf and W3proxy. I have found that these databases can grow very
quickly! So what I was trying to do is generate stats for database:w3proxy
table: WebProxyLog colums: ClientIP ClientUserName ClientAgent logDate
logTime DestHost DestIP processingtime bytesrecvd bytessent operation uri
obectsource resultcode CacheInfo rule#1 rule#2. For database:fwsrv tables:
FirewallLog colums: bytessent bytesrecvd protocol ClientIP logDate. For
Proxy Filter logs database:pf tables: PacketFilterLog colums: Pflogdate
PFlogTime SourceAddress DestinationAddress Protocol Param#1 Param#2 TcpFlags
FilterRule IPHeader Payload
Once these stats were generated and produced in XML to view on a www page I
wanted to have a stored / scheduled procedure execute some type pruning
activity to the database for the period that it generated the stats for so
that it removes the rows for each database for the date period.
Can anyone help me out...?