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 |
|
rtutus
Aged Yak Warrior
522 Posts |
 Posted - 2006-12-30 : 19:19:59
|
| I use this in a script window in SSMS:master.dbo.xp_cmdshell 'bcp myDB.dbo.DBlist out C:\myCSV1.txt -c -t -Uusrtest -Pmypassword,'I get this error:User name not provided, either use -U to provide the user name or use -T for Trusted Connectionany help pls |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2006-12-31 : 06:01:39
|
| Write the command on one line.Maybe remove the last comma.rockmoose |
 |
|
|
|
|
|
problem using xp_cmshell bcp