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 |
|
sent_sara
Constraint Violating Yak Guru
377 Posts |
 Posted - 2010-03-03 : 16:16:37
|
| Hi,can anyone help me how to store the resultset into local machine without using xp_cmdshellsince xp_cmdshell can be used only by Administration..how the normal user can do this? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sent_sara
Constraint Violating Yak Guru
377 Posts |
Posted - 2010-03-03 : 16:42:26
|
I need only through T-Sql statement, because this will be scheduled by one of our application.whether bcp works with T-Sql Statement,which I mean is through Dynamic queryquote:
Originally posted by tkizer
You can use bcp.exe, which is a command line utility. You have it on your client machine if you've got the SQL tools installed. You can also use DTS/SSIS. Why not do a simple save from the file menu though?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog"Let's begin with the premise that everything you've done up until this point is wrong."
|
 |
|
|
|
|
|
storing in local folder