BCP Question

[CliveW]

I have 3 databases on the same server, country specific databases. I have the same stored procedure to run for each database. This does a BCP export out to a text file onto another W2K box. 1 database exports all the details no problem. The other 2 databases manage only to create the txt file. No data is actually exported.

Any Ideas.

 

[SonOfEmidec1100]

A while ago I had a similar problem - BCP only exports from the default database for the user specified. To export from another database you need to qualify any tables with the database name.

Maybe this is your problem.