• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 237
  • Last Modified:

Query results from Microsoft Sql Server Analyzer

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
Lucia
Asked:
Lucia
  • 2
2 Solutions
 
jmoss111Commented:
In SSMS, click tools|options|query results|results to file
0
 
Anthony PerkinsCommented:
From Query Analyzer:
Ctrl_Shift+F
0
 
Anthony PerkinsCommented:
Actually strictly speaking that should have been:
Ctrl+Shift+F
F5
Ctrl+T
0
 
LuciaAuthor Commented:
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

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now