Hi All:
I am trying to run this code from Sql Server Query Analyzer:

DECLARE @result int
EXEC @result = xp_cmdshell 'Do D:\Temp\Prg\Test.Prg'
IF (@result = 0)
PRINT 'Success'
ELSE
PRINT 'Failure'

I get an error when I execute this code. The error is:

Server: Msg 2812, Level 16, State 62, Line 0
Could not find stored procedure 'xp_cmdshell'.
Failure

How can I execute my commend successfuly from the query analyzer?
Thanks
MA