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 |
|
subhi
Starting Member
9 Posts |
 Posted - 2010-03-02 : 13:41:24
|
| what are the several utilities avaialble to write the output to a file . I tried bcp utility it did not work having trouble with permissions when trying to write to a shared folder. what are the other options? |
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2010-03-02 : 14:24:24
|
| xp_cmdshell, but you'll also run in to permissions issues(sys admin has to enable it then grant you permissions on it. JimEveryday I learn something that somebody else already knew |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-03-03 : 09:29:18
|
| you can use OPENROWSET or Export import wizard also------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
witre the result of query to a file