[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

sql server management studio export to excel

Posted on 2009-02-23
4
Medium Priority
?
295 Views
Last Modified: 2012-08-13
i used to routinely do this. now i've changed a setting and it's not looking right, can someone please help?
0
Comment
Question by:tampa_vinnie
  • 3
4 Comments
 

Author Comment

by:tampa_vinnie
ID: 23714737
pics attached
pic1.png
pic2.png
0
 
LVL 10

Accepted Solution

by:
Marcjev earned 1000 total points
ID: 23714998
The setting that you want to check is in Microsoft SQL Server Management studio.
Go to tools option, Query results, Sql Server, general, results to grid and verify the output format is collumn aligned.
0
 

Author Comment

by:tampa_vinnie
ID: 23715551
where do I verify the output format is column aligned?
pic3.png
0
 

Author Comment

by:tampa_vinnie
ID: 23715701
i rebooted and this fixed it
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question