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
LVL 5
dtomynAsked:
Who is Participating?
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.