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 - 2002-01-31 : 00:10:34
|
| perko writes "I have a stored procedure which formates outputfrom two tables, and I need it to be saved into a text file, p.s. I know about dts, but I need to use stored procedures..." |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-01-31 : 05:16:54
|
quote:
I know about dts, but I need to use stored procedures..
Why ? What are your actual constraints ? You can call a DTS package using a stored proc if needed. Or you could use xp_cmdshell to write a file, but it is not optimal.There are other ways too (BCP etc) , but you haven't specified what goes into the text file.What are you requirements for this and you will get a better answer.Damian |
 |
|
|
|
|
|
howto write to a text file with a stored procedure