Quick question for all gurus....i want to run the job once a day instead of running all the time and dump all the event logs into staging table...any suggestions???

thanks for the reply Geoff....actually i need something similar to what you did with application log i.e without using any tool(i.e log parser) and automate the task in similar fashion....any...

where can i find Query analyzer in sql server 2008 R2 ???

help..!!!!

thank you for the prompt response...we have IIS 7.5....can you point me in the right direction what steps should i take to get IIS logs into our DBA database???

thanks in...

great article....geoff i want IIS log events in this database...how can i do that???

thanks in anticipation