I have been using SQL Server BPA for getting good information from Microsoft. I was using its 2005 version in which I used to export the results in CSV format but recently I got two new servers which has got SQL Server 2008 R2 installed on it and I know I can't run BPA 2005 on these, so chose the R2 version of it, but it doesn't have an option to save the report on CSV format, only XML, I have tried using Excel to convert it into CSV but no use, even-though it display the details but can't narrow down the results any idea of converting the results to CSV format?
Sql-server – SQL Server BPA 2008R2
sql serversql-server-2008-r2
Related Question
- SQL Server Management Studio 2014 – Fix Set Property Devices Error
- SQL Server – Export SQL Agent Jobs with Steps and Scripts
- SQL Server – How to Convert VARCHAR to DATETIME Format
- Sql-server – Automate: importing xls to table (without microsoft excel)
- Sql-server – SQL Server Deadlock issue
- SQL Server SSMS – Save Results As CSV for Excel
Best Answer
While PowerShell is high on my list of things to learn I don't know much about it right now and I needed a csv quick, so I wrote a simple query in T-SQL to get the data I needed out of the XML in a tabular format and then just copied that into excel and saved it.