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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-08-10 : 09:46:25
|
| dipti writes "When the stored procedure get executed, How to store what is displayed in the console to a log file?Thanks!" |
|
|
jeroena
Yak Posting Veteran
76 Posts |
Posted - 2006-08-10 : 10:02:34
|
| Can you please specify if you just want the output of a console in SQL Server management studio (or query analyser) written to a file, or are you building an application or a DTS / SSIS package?Jeroen |
 |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-08-10 : 10:32:45
|
| In the query analyzer, goto Tools, Options.Set Default Results target as results to file and select desired output format. click on ok to save the settings.Now execute the SP and when the file name is asked, provide a nice file name. That's it !Harsh AthalyeIndia."Nothing is Impossible" |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-08-10 : 12:49:42
|
| or Read about BCP in sql server help fileMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Storing the output of stored procedure