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 |
|
mark1504
Posting Yak Master
103 Posts |
 Posted - 2005-03-01 : 15:39:11
|
| Is it possible to have a stored procedure that creates a view then saves the data in it to a local folder? (Preferablely a TAB delimited file :-)ThanksMark |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2005-03-01 : 18:34:57
|
| No, but you can create a view and then use BCP to save the data to a folder.See BOL for details of how to use BCP.Codo Ergo Sum |
 |
|
|
|
|
|
Create a view and save as a file name.