Solved

Query results from Microsoft Sql Server Analyzer

Posted on 2009-03-31
4
182 Views
Last Modified: 2012-05-11
Hello,

I am trying to capture the results from a query and save them as text file.  But the only option I have as the RPT. and copying the results right from The results window kills my clip board.  Am I missing something other then my brain :-).

Thanks, Lucy
0
Comment
Question by:Lucia
  • 2
4 Comments
 
LVL 18

Accepted Solution

by:
jmoss111 earned 250 total points
Comment Utility
In SSMS, click tools|options|query results|results to file
0
 
LVL 75

Expert Comment

by:Anthony Perkins
Comment Utility
From Query Analyzer:
Ctrl_Shift+F
0
 
LVL 75

Assisted Solution

by:Anthony Perkins
Anthony Perkins earned 250 total points
Comment Utility
Actually strictly speaking that should have been:
Ctrl+Shift+F
F5
Ctrl+T
0
 

Author Closing Comment

by:Lucia
Comment Utility
I just saved the grid results as csv and then was able to export to excel.
Thank you both for your replies.

Lucy
0

Featured Post

Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
SQL - sum months, quarter, YTD 9 80
Sql Permission 6 42
T-SQL to Update Table Dynamically 2 30
Delete from table 6 36
Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

763 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now