SQL xp_cmdshell

See more:

SQL

server

Hi I have a SQL i want this to save the output to text file
But don't know what is getting wrong
I generate error that "Invalid object name payroll..employee_v"

But when i execute the select statement it work file
And this SQL also work fine when i put this command
SELECT * FROM pubs..authors
Please help thanks

DECLARE @FileName varchar(50),
        @bcpCommand varchar(2000)

SET @FileName = 'C:\result.txt'

SET @bcpCommand = 'bcp "SELECT * FROM payroll..employee_v ORDER BY emp_no" queryout "'
SET @bcpCommand = @bcpCommand + @FileName + '" -U sa -P 123 -c'

EXEC master..xp_cmdshell @bcpCommand