Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Pinto
Aged Yak Warrior
590 Posts |
 Posted - 2007-01-10 : 04:52:13
|
| If I run an sp in query analyser is there a way I can print the output ? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-01-10 : 04:55:01
|
| Not from QA. With SSMS you can.Well, you can print from QA too, with PRINT SCREEN option.Peter LarssonHelsingborg, Sweden |
 |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-01-10 : 05:03:13
|
| No direct way. you can output result to file and then print the file using xp_cmdshell.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-01-10 : 09:01:25
|
seems like output to file is your best option. then just print the file.
www.elsasoft.org |
|
|
|
Pinto
Aged Yak Warrior
590 Posts |
Posted - 2007-01-10 : 11:28:06
|
How do I do that Jezemine ? Easy instructions please  |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-01-10 : 12:29:03
|
in QA or SSMS, choose "results to file" instead of "results to grid". then just execute the query.
www.elsasoft.org |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2007-01-10 : 13:05:28
|
| Place your mouse pointer on the results an click, then got to the menu option File>Saves ASThen supply a file nameOpen in notepad and the printWhy what are you doing?I would invest the time in make a ore automated repeatable process howeverBrett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxAdd yourself!http://www.frappr.com/sqlteam |
|
|
|
Jeff Moden
Aged Yak Warrior
652 Posts |
Posted - 2007-01-11 : 20:45:55
|
| If you run the query using the text window for results, click in the text window and then select [File][Print] from the menu...--Jeff Moden |
|
|
|
chipembele
Posting Yak Master
106 Posts |
Posted - 2007-01-12 : 07:43:52
|
| I generally highlight it all and copy it into word. |
|
|
|
Pinto
Aged Yak Warrior
590 Posts |
Posted - 2007-01-12 : 10:37:14
|
| Now that's the really simple answer I like chipembele ! |
|
|
|
|
|
|
Print results from Query Analyser