• it would be a good idea to identify what events your trying to capture and then look up an appropriate DMV.

    Else if you right click the extended event in sql 2012 you will get an optio for data storage which will allow you to store the data into a file.

    Keep in mind that you could end up getting much more information than you actually need so its usually better to stick with a Server side trace or DMV if your only interested in troubleshooting or basic monitoring.

    Jayanth Kurup[/url]