xp_CmdShell

[Siva Ram]

Hi..

i tried to execute a select query that is written in a batch file and tried to execute it from Sql-Server Enterprise Manager ...
But the output i have got is

C:\WINDOWS\syst em32>Select top 10 name from systypes
'Select' is not recognized as an internal or external command,
operable program or batch file.

I have given the correct path of batch file..
Both Sql-Server and Batch file are in the same system...

Please Help me regarding this issue ASAP

Thank in Advance
SivaRam

[MMcCarthy]

This question is being moved to the SQL Server forum. This is the jobs forum.

ADMIN

[iburyak]

I don't see what exactly was executed and where in SQL Server Enterprise Manager. Did you mean Query Analyzer?