DosTips.com

Hi,

I get the error '"type e:\test.txt|find /n /v """' is not recognized as an internal or external command, operable program or batch file.

But, it works fine, if the SQL User has sysadmin privilege or if executed via windows authentication from SQL management studio.

Any advice on this will be appropriated.

Thanks,
Austin

What exactly is the command line that causes this error? And why did you use TYPE to pipe the output to FIND? You can use FIND directly.

Regards
aGerman

Hello aGerman,

1'st of all thanks for your response.

The command is as follow :-

command exec p_fncDeleteFTPFilename 'filename.txt', 'filename2.txt'

Can you advice anything on this ?

Regards,
Austin

Have a look at your error message. This line can't be the reason, because there is no "type" or "find" command and it seems not to be a batch code.

Regards
aGerman

The Interesting part is that it works fine when we login as windows administrator or if the user as sysadmin previlage.

Command prompt accesses the file system, so it sounds like an internal privilege issue. You might have to figure this one out yourself...