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 |
|
yalgaar
Starting Member
43 Posts |
 Posted - 2006-03-15 : 16:13:08
|
| I have a SP that will return huge amount of data. How do I get this data to a file? Basically I cannot use "Output to file" option. IfI use that, I will get the output that is from the "Grids" table and not from the "Messages" tab.I want the output that normally is seen on the "Messages" tab.Thanks in Advance. |
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2006-03-15 : 16:52:46
|
| Set two options:1) Query/Results In Text2) Tools/Options/Results/Default results target: Results to fileYou may also need to set:3) Tools/Options/Results/Max char per column: (Whatever size you need...) |
 |
|
|
yalgaar
Starting Member
43 Posts |
Posted - 2006-03-15 : 16:56:34
|
quote:
Originally posted by blindman
Set two options:1) Query/Results In Text2) Tools/Options/Results/Default results target: Results to fileYou may also need to set:3) Tools/Options/Results/Max char per column: (Whatever size you need...)
Result to text will not work incase of a huge output. I cannot copy the output in the clipboard.Result to File will only give me the results that appear in the "GRIDS" tab and not on the "Message" tab. |
|
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2006-03-15 : 17:25:10
|
| Obviously, you have not even tried what I suggeste.Sigh. Oh well.... |
|
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2006-03-15 : 17:26:30
|
| Wait. My apologies. You WANT the messages (rowcounts, etc...)? |
|
|
|
yalgaar
Starting Member
43 Posts |
Posted - 2006-03-15 : 17:43:31
|
quote:
Originally posted by blindman
Wait. My apologies. You WANT the messages (rowcounts, etc...)?
I need everything that is displayed in the "Message" tab |
|
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2006-03-15 : 18:19:07
|
Ok, bear with me here, because this is kind of an odd request. You stated in your original post:quote:
Originally posted by yalgaar
I have a SP that will return huge amount of data. How do I get this data to a file?
But really, you don't want the data at all? You just want the messages? And are you telling me that there are too many messages to copy and paste?I can think of two hacks to do this. The first is to execute your query using the output file parameter. Another would be to schedule a job that runs your code and specify an output file for the step. Both of these methods will capture both data and messages, though. |
|
|
|
|
|
|
Query Analyzer- Results