Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 695
  • Last Modified:

Easy BCP question

I just can't seem to remember the correct way to do BCP using trusted connection (NT Authentication).  I checked BOL and all the examples I ever see always have -U and -P.  Does anyone have the syntax?  Do I just exclude them (this doesn't seem to work for me).

Thanks
0
dtomyn
Asked:
dtomyn
  • 2
1 Solution
 
troutaCommented:
I believe it is -T for a trusted connection, if unsure just type 'bcp /?' at the command line and it will display the command line parameters.
0
 
dtomynAuthor Commented:
no, that's not it... -T is [text or image size]
0
 
aponcealbuerneCommented:
bcp DataBase..Table out filename.dat -c -T

(-T) definitively is Trusted Connection at least in MS SQL 7.0

hope helps
0
 
dtomynAuthor Commented:
I'm on SQL 2000... I'm just going by what the command prompt says when I type it in...

0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now