Viewing 6 posts - 1 through 6 (of 6 total)
Ok, here is the weird thing. This statement works:
SET @bcpCommand = 'bcp "SELECT * FROM (database)..(table)" queryout "E:\CMS\color.txt" -U (user) -P (pw) -c'
This statement doesn't:
SET @bcpCommand = 'bcp "SELECT * FROM (database)..(different...
February 11, 2005 at 1:00 pm
With your permissions problem, are you referring to the ability to create files on the drive, ability to access tables, or something entirely different? Thanks for your suggestions.
February 11, 2005 at 12:19 pm
I had added the -t and -r in there while I was trying to get it to work. It still errors out without them. I also tried placing the username...
February 11, 2005 at 8:38 am
Krystian,
You can't assign parameters there, because technically they aren't parameters. Parameters are passed into stored procedures, and that is just a query. If you place that query in a stored...
February 4, 2005 at 1:30 pm
Edwin,
I don't think you can do what you want to do. I was looking at doing something similar this week. I looked all over the internet, but I couldn't find...
February 4, 2005 at 1:24 pm
Viewing 6 posts - 1 through 6 (of 6 total)