kdbworld
asked on
Stored procedure error [SQLSTATE 4200] (Error 2812). This step failed
Hi,
I'm receiving the following error "Could not find stored procedure 'master..xp_cmshell'. [SQLSTATE 42000] (Error 2812). The step failed." when I execute my stored procedure.
Here is the stored procedure syntax.
DECLARE @sql VARCHAR (8000);
SELECT @sql = 'bcp "SELECT * FROM dbo.vw_DirDailyActual ORDER by Date, DirCode" queryout
"P:\Shared Information\Extracts\DB_Ad min\dirdai lyactual.c sv" -T -c';
exec master..xp_cmshell @sql;
I have admin privileges. Please advised
I'm receiving the following error "Could not find stored procedure 'master..xp_cmshell'. [SQLSTATE 42000] (Error 2812). The step failed." when I execute my stored procedure.
Here is the stored procedure syntax.
DECLARE @sql VARCHAR (8000);
SELECT @sql = 'bcp "SELECT * FROM dbo.vw_DirDailyActual ORDER by Date, DirCode" queryout
"P:\Shared Information\Extracts\DB_Ad
exec master..xp_cmshell @sql;
I have admin privileges. Please advised
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
No worries. There are times that a 2nd pair of eyes is necessary. It happens to everyone.
Cheers.
Cheers.
ASKER