dionisio_79
asked on
how to pass initial catalog parameter to bcp
Hi Experts,
can I pass the initial catalog as a parameter to my bcp?
can I pass the initial catalog as a parameter to my bcp?
ASKER
bcp "select * from dbo.app_bretella" queryout "C:\Documents and Settings\EE20019\My Documents\we.txt " -t ; -S ...SERVERNAME -d ...DATABASENAME -U secretoUR -P secretoUR -c
i GET AN UNKNOWN OPTION -d
are you sure you are using the SQL Server bcp, and don't have another bcp in the "path"?
that's what I have seen as usual reason for this "error"
that's what I have seen as usual reason for this "error"
ASKER
sure, no other bcp executables in the path
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
tryied without spaces, same result
ASKER
any other suggestions?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
the option is -d<databasename>