Solved

Easy BCP question

Posted on 2002-03-21
4
682 Views
Last Modified: 2012-05-04
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
Comment
Question by:dtomyn
  • 2
4 Comments
 
LVL 3

Accepted Solution

by:
trouta earned 50 total points
Comment Utility
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
 
LVL 5

Author Comment

by:dtomyn
Comment Utility
no, that's not it... -T is [text or image size]
0
 
LVL 4

Expert Comment

by:aponcealbuerne
Comment Utility
bcp DataBase..Table out filename.dat -c -T

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

hope helps
0
 
LVL 5

Author Comment

by:dtomyn
Comment Utility
I'm on SQL 2000... I'm just going by what the command prompt says when I type it in...

0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

In this article—a derivative of my DaytaBase.org blog post (http://daytabase.org/2011/06/18/what-week-is-it/)—I will explore a few different perspectives on which week today's date falls within using Microsoft SQL Server. First, to frame this stu…
When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now