Activity overview
Latest activity by Brian_M
Thanks for your reply Jon. Copy with headers is not great options because often my data has CR/LF in it, which does not work well. Save as CSV does work decently, but the formatting is different than if I am able to just open in Excel. A Save as XLSX would be a great option. That being said, I think I found an interesting workaround by first opening the admin version of SSMS, then opening SSMS under my normal account. For whatever reason it now allows me to Open in Excel with the normal user, even though I am in the admin version of SSMS. / comments
Thanks for your reply Jon.Copy with headers is not great options because often my data has CR/LF in it, which does not work well. Save as CSV does work decently, but the formatting is different tha...
Runas User and Export to Excel
I sometimes have to log into SQL servers using an administrator account and when I go to export to Excel it automatically tries to open the file using the runas user (local computer admin). That us...