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 |
|
fmardani
Constraint Violating Yak Guru
433 Posts |
 Posted - 2006-03-14 : 07:16:47
|
| How do I get access to bcp in sql server 2005 please?Thanks |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2006-03-14 : 07:30:45
|
| Via the command line or xp_cmdshell.. |
 |
|
|
fmardani
Constraint Violating Yak Guru
433 Posts |
Posted - 2006-03-14 : 07:46:05
|
| HOw do I get to command line in sql server?Thanks |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2006-03-14 : 07:51:04
|
Lookup xp_cmdshell in BOL..something like:exec xp_cmdshell 'bcp "SELECT au_fname, au_lname FROM pubs..authors ORDER BY au_lname" queryout Authors.txt -c -Sservername -Usa -Ppassword' EDIT: Didn't realise it was 2005, you will have to make sure you have access tp xp_cmdshell by running the surface area configuration utility.. |
|
|
|
|
|
|
bcp