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...

Ok, thanks, I'll check with my DBA.

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.

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...

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...

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...