Home Forums SQL Server 2005 SQL Server 2005 General Discussion BCP Error On New Server RE: BCP Error On New Server

  • September 19, 2012 at 8:56 am

    #1539613

    YSLGuru (9/19/2012)

    Thanks for the suggestion Jeff but I'm using the same account on the new server that I was on the old and both servers on on the same domain. I'm no IT admin type but does anyone know if within a Windows domain its possible for an account run from one server to have different permissions then when the same account is run/used on another server if both servers are in the same domain? Thats the only thing I can think of.

    Thanks

    Did you try my suggestion with the -S parameter included?

    SELECT @sMysql = 'bcp "SELECT sOutput FROM MYDATABASE.dbo.VPOSITIVEPAY" queryout ' + @sFilePath + @sFileName + ' -S [SQLSVR04\SS2005] -T -c'